"order by" in many to many...

[autumn]

Hi this might sound like a silly question and I'm not sure if there is a way to achieve this:

I have 3 tables, lets say one holds people's names, one holds color names and the 3rd table links the two. So it will say for example Joe, Jack and Jill like the colour Yellow.

if I want to query the 3rd table that only holds indexes of the other two tables, how can I sort the records alphabetically by the person's names?

so the 3rd table will look like this

Name - Color
1 --------- 3
2 --------- 3
5 --------- 3

if I order by Name, it will sort the records by their ID.

I hope that makes sense.

Any ideas?

A.

[cleromancer]

I think I understand.. I hope im on the right track.

nme (nme_id, nme_nme)  // names
nmecol (nmecol_nme_id, nmecol_col_id)  // table linker
col (col_id, col_nme)  // colours

SELECT col_nme FROM nme 
LEFT JOIN nmecol ON nme_id = nmecol_nme_id
LEFT JOIN col ON nmecol_col_id = col_id
(then do your sorts on nme_nme)