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!