SQL INNER JOIN vs LEFT JOIN vs RIGHT JOIN vs FULL OUTER JOIN: Differences With Examples (Tested in MySQL 8.4 and SQLite)

INNER JOIN returns only the rows that match in both tables. LEFT JOIN returns every row from the left table, with NULL where the right table has no match. RIGHT JOIN is the mirror image: every row fro