I have Table1: data1 data2 data3 nameID -> id of record in Table2
I have Table2 id name1 name2
I'd like to select all records from table 1, and have them sorted by name1.
What's the best way to do this?
Try this:
SELECT t1.* FROM Table1 t1 INNER JOIN Table2 t2 ON t2.id = t1.nameID ORDER BY t2.name1
Does that work for you?
However, the above solution does not output the column you are sorting by, so what practical good does this sorting do you?
Also, all records in data1 which have the same nameID value will be unsorted within themselves, if that matters.
-- Darren Duncan
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
