Pivot question

[PEJO]

Assuming I have 2 tables.


t_sexes

sex_ID Sex_Name
1 Male
2 Female

and

t_names

name_ID name_name sex_id
1 jon 1
2 jason 1
3 Sue 2
4 Bill 1
5 Sally 2

How can I have my results show like this.

Male Jon Jason Bill
Female Sue Sally

I have limited experience with pivot tables but I assume this is the way to
go......thanks in advance for ahy help.


--

 

[pottymouthed]

Please ignore the repost...the original was not showing up for some
reason..