The JOIN Keyword

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.

Get Sams Teach Yourself MySQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.