The INNER JOIN matches each row in one table with every row in other tables and allows you to query rows that contain columns from both tables. The INNER JOIN is an optional clause of the SELECT ...