Something like: SELECT subject, lastposter, views, replies, lastpost, users.name, users.date, users.regdate FROM thread LEFT JOIN users ON thread.lastposter = users.name ORDER BY lastpost DESC LIMIT 10
should work. Pretty self-explanatory. On 10/30/06, Jason <[EMAIL PROTECTED]> wrote:
Thanks for the reply I have tried assigning the var via $query1 , but because I have the nested query inside the other one then I get the result 10 times over , As has been suggested I guess the best option would be a table join but I am not up with the play on joins , ie left join etc so I am a little stuck.
