fm86 - 7:17 am on Jun 29, 2011 (gmt 0)
In mySql I have two tables 'Books'('id', 'title') and 'Chapters'('id', 'text', 'booksId', 'date'). Authors can add chapters to books. I would like to select all the books and order them so that the books whose chapter is more recent are displayed first. I tried with an inner join but I probably did it wrong.
The concept is first order chapters by descending date and retrieve the corresponding book
Can someone help me?
Thanks a lot!