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

5 votes136 views1 answer
Python generate id
Python
0 vote136 views1 answer
Python code for calculating probability of random variable
Python
1 vote240 views1 answer
Django foreign key error Cannot assign must be a instance
Python
0 vote117 views3 answers
How to transpose a matrix in python
Python
0 vote132 views1 answer
Ping all IP addresses in a network
Python
0 vote129 views1 answer
How to view the complete data frame in pandas
Python
0 vote136 views1 answer
Create database tables python
Python
2 votes159 views2 answers
Random dice python
Python
3 votes125 views2 answers
Python initialize list
Python
0 vote142 views1 answer
Python fillna with mean in a dataframe
Python