Question

What is Left Join in SQL?

Answer 1

The Left Join is used to fetch all rows from the left-hand table and common records between the specified tables. It returns all the rows from the left-hand side table even though there are no matches on the right-hand side table. If it will not find any matching record from the right side table, then it returns null. This join can also be called a Left Outer Join.

The following visual representation explains it more clearly:

SQL Interview Questions and Answers

The following syntax illustrates the RIGHT JOIN:

SELECT colum_lists    

FROM table1     

LEFT JOIN table2    

ON join_condition;