Home Forums SQL Server 2005 Administering How to write Query on the Result Set of Another Query RE: How to write Query on the Result Set of Another Query
lrosini
Default port
Points: 1480
More actions
October 11, 2013 at 1:53 pm
#1658018
Maybe something like this
with cte (ID, somefield) as
(
select ID, FieldName from TableA
)
select TableB.Field
from TableB
join cte
on cte.ID = TableB.ID