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

  • 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