SQL Left and Right joins
A SQL JOIN clause is used to combine rows from two or more tables, based on a related column between them. This is referred to as a key. In a relational database there would be a primary key and corresponding foreign key across all the tables which you are joining. Think of this like the tables personal identification.
There are four basic types of SQL joins:
Inner Join Left Outer Join Right Outer Join Full Join Today we will cover two of these joins: Left and Right, stay tuned for upcoming posts covering Inner and Full Join.