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

21 votes237 views2 answers
Run python file using python code
Python
1 vote205 views1 answer
Install quick-mailer
Python
2 votes230 views3 answers
How to hack instagram account using python
Python
0 vote223 views1 answer
Get cuda memory pytorch
Python
1 vote226 views2 answers
Maximizar ventana tkinter python
Python
0 vote229 views1 answer
Michelin primacy 4
Python
7 votes214 views4 answers
Pandas filter rows by value
Python
1 vote219 views1 answer
Dataframe describe in pandas problems
Python
0 vote217 views1 answer
Pandas describe get mean min max
Python
0 vote234 views1 answer
Then generate Django project from the project template of cookiecutter
Python