LEFT, RIGHT and FULL joins

About this topic

Keep unmatched rows and see NULLs.

Part of SQL & DBMS: 22 topics, 5 free.

More topics in this course

• What is a database? Tables, rows, columns
• SELECT and WHERE
• ORDER BY, LIMIT, DISTINCT, LIKE
• COUNT, SUM, AVG, MIN, MAX
• GROUP BY and HAVING