10 docs tagged with "joins"

Simplify SQL join queries using table and column aliases.

Understand special join types including CROSS JOIN and SELF JOIN.

Return all rows from both tables using FULL OUTER JOIN, with NULLs where no match exists.

Combine rows with matching values in both tables using INNER JOIN.

Learn how to combine JOINs and aggregate functions like COUNT and SUM.

Include unmatched rows from the left table using LEFT JOIN.

Learn how to join three or more tables in a single SQL query.

Include unmatched rows from the right table using RIGHT JOIN.

Reflect on core SQL techniques practiced throughout the course.

Understand the purpose of joins in SQL.