MS SQL Server Joins Question:
Download Job Interview Questions and Answers PDF
What is LEFT OUTER JOIN?
Answer:
A left outer join or a left join returns results from the table mentioned on the left of the join irrespective of whether it finds matches or not. If the ON clause matches 0 records from table on the right, it will still return a row in the result—but with NULL in each column.
Example: To display employees irrespective of whether they have got bonus.
Select * From employee LEFT OUTER JOIN bonus ON employee.bonusID=bonus.bonusID
Example: To display employees irrespective of whether they have got bonus.
Select * From employee LEFT OUTER JOIN bonus ON employee.bonusID=bonus.bonusID
Download SQL Server Joins Interview Questions And Answers
PDF
Previous Question | Next Question |
What is OUTER JOIN? | What is RIGHT OUTER JOIN? |