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 vote270 views2 answers
Torch.cat
Python
0 vote266 views2 answers
A problem of predicting whether a student succeed or not based of his GPA and GRE. for logistic regression
Python
0 vote240 views3 answers
Outliers removal
Python
6 votes236 views3 answers
Django filter install
Python Django
7 votes232 views5 answers
.format python 3
Python
24 votes245 views5 answers
Load static
Python
-2 votes259 views5 answers
Convert python to java
Python
-1 vote236 views1 answer
How to store categorical variables in separate dataframe
Python
89 votes243 views6 answers
Sleep python
Python
2 votes254 views1 answer
Flask minimul app
Python Flask