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

8 votes287 views4 answers
Pandas print duplicate rows
Python
49 votes291 views6 answers
How to color print in python
Python
0 vote271 views1 answer
Identify Null and NAN python
Python
0 vote288 views1 answer
Django http response 204
Python Django
1 vote248 views1 answer
Serving static audio files with flask in react
Python
0 vote272 views1 answer
How many perfect squared lie between 1 and 400
Python
0 vote283 views1 answer
How to round off values in columns in pandas in excel
Python
0 vote300 views1 answer
Dockerize django app
Python Django
70 votes267 views6 answers
Get list of files in directory python
Python
2 votes279 views1 answer
Remove comma from string python column
Python