SQL INNER vs OUTER join

11 Feb 2014

What is inner join? What is outer join? What are the differences?

What is left outer join? What is right outer join? What is full outer join?

These questions are better explained by Venn Diagram: