Tried distinct but does not work ...

Tried distinct however does not work to eliminate repeat output of 
department name. Only want department name to print once with all 
members then next department name and members etc.

select (cccb_name) as 'cccb', CONCAT(member_fname,' ',member_lname) as 
'member ' from member, cccb, member_cccb_lnk where cccb.cccb_id = 
member_cccb_lnk.cccb_id


  Advisory department	 Tom Baster
  Advisory department	 Jim {*filter*}
  Advisory department	 Frank Mustard
  Advisory department	 Julie Trees
  Advisory department	 Jeff Black
  Advisory department	 Louis Chad
  Affirmative Action Department	 Jeff Black
  Approval Department	 Julie Trees
  Development department	 Jeff Black
  Ethics department	 Jim {*filter*}
  Finance department	 Tom Baster
  Finance department	 Tony Tomas
  Finance department	 Jim {*filter*}
  Finance department	 Denny Rest

This is a problem of data display, as opposed to data retrieval and,
as such, would usually be handled in PHP for instance. However, one
solution was very recently described over at the mysql newbie forum:
 http://www.**--****.com/ ,151726,151939#msg-151939

select if(@prev=cccb_name,'',@prev := cccb_name) as 'cccb',
CONCAT(member_fname,' ',member_lname) as
'member ' from member, cccb, member_cccb_lnk where cccb.cccb_id =
member_cccb_lnk.cccb_id

I will read your url but I used your sql and it presented a cartesian 
product.

Ok, the script I provided was incorrect. Following is correct.

select (cccb_name) as 'cccb', CONCAT(member_fname,' ',member_lname) as 
'member ' from member, cccb, member_cccb_lnk where cccb.cccb_id = 
member_cccb_lnk.cccb_id
and member.member_no = member_cccb_lnk.member_no order by cccb asc

However, modified above with your mod and I think it is correct but it 
provides the same out. The cccb is repeated as before.


select if(@prev=cccb_name,'',@prev := cccb_name)  as 'cccb', 
CONCAT(member_fname,' ',member_lname) as 'member '
from member, cccb, member_cccb_lnk where cccb.cccb_id = 
member_cccb_lnk.cccb_id
and member.member_no = member_cccb_lnk.member_no order by cccb asc;


select (cccb_name) as 'cccb', CONCAT(member_fname,' ',member_lname) as 
'member '
from member, cccb, member_cccb_lnk where cccb.cccb_id = 
member_cccb_lnk.cccb_id
and member.member_no = member_cccb_lnk.member_no order by cccb asc;

It doesn't work because strawberry missed out a very important part of the 
total query when he posted here, although the clue was in the link he posted 
if you looked carefully.
Try:
SET @prev = '';
select if(@prev=cccb_name,'',@prev := cccb_name)  as 'cccb',
CONCAT(member_fname,' ',member_lname) as 'member '
from member, cccb, member_cccb_lnk where cccb.cccb_id =
member_cccb_lnk.cccb_id
and member.member_no = member_cccb_lnk.member_no order by cccb asc;