SELECT * FROM Table1 T1 CROSS APPLY [SUBQUERY] AS T;