I have two tables, A and B, where the entries in B are connected to A through a left join. Thus there may be several entries in B for each post in A.
Now I would like to select the two latest posts in A and all the corresponding posts in B. I tried something like SELECT fields FROM A LEFT JOIN B ON B.aID = A.ID ORDER BY A.ID DESC LIMIT 2, but that only got the latest two entries in B and the last entry in A (which corresponds to them both). Then I tried using some GROUP BY statements, to no avail. Please help!
you have to use two querys or subselects
-- Sebastian Mendel
www.sebastianmendel.de www.tekkno4u.de www.nofetish.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
