Difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL OUTER JOIN

• Lucas
• August 07, 2015

The SQL language allows tables to be joined, but sometimes these commands are forgotten and/or we get confused about the real purpose of each one. Let’s take a look at the image below, representing the various forms of JOINS: INNER JOIN Intersection between tables. Example: SELECT <colunas> FROM Table_A A INNER JOIN Table_B B ON