🔗 SQL JOINs

A JOIN merges rows from two or more tables based on a related column. Most-used types: INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN.

📖 Example: INNER JOIN

Query result will appear here...

📌 JOIN Syntax

SELECT — Choose which columns to return.
FROM — Base table.
INNER JOIN — Combine records that have matching values in both tables.
ON — Specify which columns to match on.

💡 Tip: An INNER JOIN only returns rows when there’s a match in both tables. Use a LEFT JOIN if you want all rows from the left table regardless.