Sams Teach Yourself MySQL in 10 Minutes

In the previous lesson, you learned how to join two or more database tables by specifying a list of table names in the FROM clause of the SQL statement.

MySQL provides an alternate syntax using the JOIN keyword that allows several different types of table joins to be performed.