A couple of examples of using joins or nested queries to select and combine data from multiple tables.
A tutorial on MySQL Left Joins