Date: 01/11/06 (MySQL Communtiy)    Keywords: no keywords

Hi I was wondering if it's possable to nest a query like this

SELECT * FROM t1 ORDER BY(SELCT name FROM t2 WHERE t2.id = t1.uid)

Essentially I have 2 linked tables one holing user names and the other holing recipies and I'd like to order them by the posters name not the order in which they joined.

Any help would be much appreciated.

TIA

Paul

Source: http://community.livejournal.com/mysql/81232.html