• OUTER APPLY is very different from OUTER JOIN which is where you would expect to see "the condition to join the tables".

    From http://msdn.microsoft.com/en-us/library/ms175156.aspx

    The APPLY operator allows you to invoke a table-valued function for each row returned by an outer table expression of a query.

    APPLY is very useful (and awesome) and worth the time to get to know.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato