Understanding Joins in SQL

Complete Syntax Common Usage
FULL INNER JOIN INNER JOIN or simply JOIN
FULL OUTER JOIN FULL JOIN
LEFT OUTER JOIN LEFT JOIN
RIGHT OUTER JOIN RIGHT JOIN
CROSS JOIN CROSS JOIN

RIGHT INNER JOIN and LEFT INNER JOIN are non-existent syntax because results are the same as in INNER JOIN.

Posted in Uncategorized | Leave a comment