I am still learning new T-SQL operators. Today I discovered CROSS APPLY, which is for joining to a table-valued function (with parameters pulled from the other tables).