left join outer apply

1--Script #3 - OUTER APPLY and LEFT OUTER JOIN
2
3SELECT * FROM Department D 
4OUTER APPLY 
5   ( 
6   SELECT * FROM Employee E 
7   WHERE E.DepartmentID = D.DepartmentID 
8   ) A 
9GO
10 
11SELECT * FROM Department D 
12LEFT OUTER JOIN Employee E ON D.DepartmentID = E.DepartmentID 
13GO