Wondering if anyone can help me with the proper syntax for an ORDER BY clause with a subquery. What I have is a table column named make in one table. The make column contains a Serial ID of the name which is stored in an alternate table named sections. I am trying to be able to ORDER by on make, but as you can guess it is ORDERING by the ID rather than the actual Name.
Select * from floors Where system = 1 ORDER by make This sorts by the Serial ID's in column make I would like to be able to sort by the actual Names associated back from the ID's. Anyway of doing this?? Thanks All for the Help! ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
