SQL Server: When We Use Cross or Outer Apply Instead of Simple Joins

added by lionofdezert
2/4/2011 10:55:21 PM

1 Kicks, 113 Views

APPLY statements are used for joining purpose just like simple JOIN statements. Cross Apply is just like INNER JOIN and Outer APPLY is just like LEFT OUTER JOIN.