We're sorry but this app doesn't work properly without JavaScript enabled. Please enable it to continue.

This lesson's interactive features are locked, please to keep using them

Full Join

A FULL JOIN combines the result set of the LEFT JOIN and RIGHT JOIN commands. It returns all records from both table_a and table_b regardless of whether or not they have matches.

Compare the Join Types

Switch between join types below to see which rows survive. Margaret has no dept_id, and the Design department has no employees, so they only appear once you reach a FULL JOIN. Hover a row to trace where it goes.

Interactive example available with JavaScript enabled.