title: Mysql sort aggregated rows by date
body: <p>I think this is a simple question: I'm just new to php and can't really figure this out in an efficient way. What I want to do is for each friend, query all the posts and return a single list thats sorted by the date. But they are two different tables and I don't really understand how the tables could be joined with a single statement nor if this is even the best scalable solution. Help is greatly appreciated! :)</p>