2 ms·
in SQLSERVER you could build your selects (using unique names or aliases) and then wrap it all in a common table expression like so: ; with cte as ( select a a
by gigatexal 9y ago
in SQLSERVER you could build your selects (using unique names or aliases) and then wrap it all in a common table expression like so:
; with cte as
( select a as A, b as B, c as C from dbo.table1 tbl1 join dbo.table2 tbl2 on tbl2.id = tbl1.id) select A, B, C from cte