SQL ORDER BY question

[micmac]

Hi all,
By viewing the code below can anyone tell me how to rewrite the code so that i can query another table called 'pref' and order by the field called 'location' from that table.

Thanks,
micmac

$result = mysql_query("SELECT * FROM cat1 WHERE CatParent = $id AND state_county='$state_county' AND active='yes' AND country IN('Global', 'US') ORDER BY pref,CatName");

[tomhath]

select * from pref order by location

Reread your post. How could anyone possibly give a sensible answer?

[dizzutch]

order by pref.location asc

something like that seems obvious.