SQL JOINS

Left Outer Join: select column from table1 a left join table2 b on  a = b

Right Outer Join: select column from table1 a right join table2 b on  a = b

Left Excluding Join: Select column from table1 a left join table2 b on  a = b where b is null

Right Excluding Join: Select column from table1 a right join table2 b on  a = b where  a is null

Inner Join: Select column from table1 a inner join table2 b on  a = b

Outer Join or full outer Join or full join: select column from table1 a full outer join table2 b on  a = b

Outer Excluding Join: select column from table1 a full outer join table2 b on  a = b where  a is null or b is null