Pivot question

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.


--
------------------------------------------------------
"A comet is, of course, frozen bodies of ice and dust formed over 4.6
billion years ago---or created 6,000 years ago, depending on whether or not
you're wrong."
---Jon Stewart

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


PEJO wrote:
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.


--
------------------------------------------------------
"A comet is, of course, frozen bodies of ice and dust formed over 4.6
billion years ago---or created 6,000 years ago, depending on whether or not
you're wrong."
---Jon Stewart