Cross Apply vs Outer Apply

CROSS APPLY is equivalent to an INNER JOIN expression and OUTER APPLY is equivalent to a LEFT OUTER JOIN expression.

http://sqlwithmanoj.wordpress.com/2010/12/11/cross-apply-outer-apply/

---