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 vote357 views1 answer
Django admin.py date format
Python Django
2 votes329 views1 answer
Minimal flask application import
Python Flask
0 vote304 views1 answer
Python3 boto3 put object to s3
Python
0 vote312 views1 answer
Json to argparse
Python
114 votes319 views6 answers
Amc price
Python
0 vote304 views1 answer
Python write list to excel file
Python
0 vote325 views1 answer
Multiple assessment in python
Python
1 vote358 views1 answer
How to check the django version on a mac
Python Django
0 vote274 views1 answer
Vigenere cipher with all printable characters python
Python
1 vote351 views1 answer
Django filter not equal to
Python Django