SELECT Main.title, Replies.date FROM (Main LEFT JOIN Replies ON Main.id = Replies.main_id) ORDER BY Replies.date
That should do it. Mike BlueBytes wrote: >http://paa.fragland.net/hosted/myquestion/ > >here you find my question, thx > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]