Left join outer apply

--Script #3 - OUTER APPLY and LEFT OUTER JOIN

SELECT * FROM Department D 
OUTER APPLY 
   ( 
   SELECT * FROM Employee E 
   WHERE E.DepartmentID = D.DepartmentID 
   ) A 
GO
 
SELECT * FROM Department D 
LEFT OUTER JOIN Employee E ON D.DepartmentID = E.DepartmentID 
GO

Source: mssqltips.com

Similar codes

0 vote134 views1 answer
Last executed query in flask api
Python
0 vote137 views1 answer
Convert 2d string array to float python
Python
1 vote145 views1 answer
How to check for duplicates in a column in python
Python
1 vote116 views1 answer
Load diamonds dataset from sns
Python
8 votes128 views1 answer
Convert column string to int pandas
Python
0 vote134 views1 answer
How to store something in python
Python
14 votes140 views3 answers
Matplotlib make bigger sublots
Python
0 vote159 views1 answer
For loop in django template css
Python Django
2 votes149 views2 answers
How to find anyone's ip address
Python
1 vote128 views1 answer
How to declare private attribute in python
Python