Code Editor

Query Results

Run a query to see results.

Database Schema

Schema undefined.
Multiple Tables

Left Outer Join

SELECT * FROM albums LEFT JOIN artists ON albums.artist_id =;

Outer joins also combine rows from two or more tables, but unlike inner joins, they do not require the join condition to be met. Instead, every row in the left table is returned in the result set, and if the join condition is not met, then NULL values are used to fill in the columns from the right table.

The left table is simply the first table that appears in the statement. Here, the left table is albums. Likewise, the right table is the second table that appears. Here, artists is the right table.

Report a Bug
If you see a bug or any other issue with this page, please report it here.