Data From 2 Tables in one Query?

[Kristoph]

I find referencing 2 tables at once can be made much easier to understand by using aliases in your query, eg:

SELECT t1.field AS field1, t2.anotherfield AS field2 FROM user AS t1, post AS t2 WHERE t1.userid = t2.userid AND t2.postid = '11111'