What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN?

Question

Anubhav Sharma · Answer

Here’s the short and clear difference: INNER JOIN Returns only the matching records from both tables.→ Common data only LEFT JOIN (LEFT OUTER JOIN) Returns all records from left table + matching from right.→ Non-matching right = NULL RIGHT JOIN (RIGHT OUTER JOIN) Returns all records from right table + matching from left.→ Non-matching left = NULL FULL JOIN (FULL OUTER JOIN) Returns all records from both tables.→ Non-matching on either side = NULL Quick Example Idea INNER → intersectionLEFT → left + matchRIGHT → right + matchFULL → everything

forum

What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN?

Can you answer this question?

1 Answers

INNER JOIN

LEFT JOIN (LEFT OUTER JOIN)

RIGHT JOIN (RIGHT OUTER JOIN)

FULL JOIN (FULL OUTER JOIN)

Quick Example Idea