What is left join in database?
By Arsal Ahmed Posted on March-20-2018 578
LEFT OUTER JOIN:
Another type of join is called a SQL Server LEFT OUTER JOIN. This type of join returns all rows from the LEFT-hand table specified in the ON condition and only those rows from the other table where the joined fields are equal (join condition is met).
Syntax:
The syntax for the LEFT OUTER JOIN in SQL Server (Transact-SQL) is:
SELECT columns FROM table1 LEFT [OUTER] JOIN table2 ON table1.column = table2.column;
By Arsal Ahmed 20-Mar-2018 Views 578