Hello, 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! Thanks in advance, J.
