Left Join
- which instructs the server to include all rows from the table on the left side of the join
- The keyword left indicates that the table on the left side of the join is responsible for determining the number of rows in the result set, whereas the table on the right side is used to provide column values whenever a match is found