Sams Teach Yourself MySQL in 21 Days, Second Edition

Q&A

Q1:	How can I select from more than one table at a time?
A1:	If you want to cross-reference rows of one table with those of a second (or indeed a number of tables), you want to perform a join. See tomorrow's lesson for information on how to perform joins. Alternatively, if you want to select data from one table and combine it to data selected from another, you should consider using UNION, as described previously.