SQL FULL Join

The SQL FULL JOIN combines results from a left and right outer join into one result.  Or in other words, it is an inner

SQL FULL Join

SQL Right Join

The SQL RIGHT JOIN Includes all rows from the Right table and those that match from the left.  For that doesn’t match from the right, NULL is

SQL Right Join

SQL Left Join

The SQL LEFT JOIN Includes all rows from the left table and those that match from the right table. When the right table doesn’t

SQL Left Join

SQL Cross Join

Use SQL cross joins when you wish to create a combination of every row from two tables.  All row combinations

Cross Join Meme
SQL Cross Join