Menu
I have one db table “equipment” with a field called “equipManu”. This field is populated with an id# from another table call “manufacturers.” The issue is when I want to sort the equipment table by manufacturer. When I ORDER BY equipManu, it orders by the ID number that populates that field and not the manufacturer name that the ID# is associated with. Is there a way it can order alpha by the manufacturer NAME from that other table? I bet this is an easy solution…
equipID(int)
equipManu <– Uses manuID from manufacturers
…
manuID(int)
manuName <– Want to alpha order by this value
…