For example, say the query is
Code: Select all
SELECT links FROM table1Anyone know how to do this?
Moderator: General Moderators
Code: Select all
SELECT links FROM table1Code: Select all
SELECT t1.`links`
FROM `table1` AS t1
JOIN `table2` AS t2
ON t1.`linkname`=t2.`linkname`
ORDER BY t2.`othercolumn`