SQL JOIN Practice Lab

SQL JOIN Lab

Master all JOIN types with interactive practice

📊 Demo Datasets

employees

departments

projects

💻 SQL Query Editor

Available Tables: employees, departments, projects
Tip: Try different JOIN types to see how they affect the results!

INNER JOIN

Matching rows only

LEFT JOIN

All from left + matches

RIGHT JOIN

All from right + matches

FULL JOIN

All rows from both

CROSS JOIN

Cartesian product

✨ Query Results

👋 Write a SQL query above and click "Run Query" to see the results here!