Search notes:
SQL Server: cross apply / outer apply
See also
Joining with table valued functions
cross apply
in Oracle
Index