How can I sort one table by a column in another in MySQL?
- by George Edison
Say I have a table named items:
id int(11)
...
tag int(11)
And another table named tags:
id int(11)
name varchar(255)
The tag column in items is an index into the tags table. How can I select some rows from the items table and sort the results by the name column in tags?