Home Forums SQL Server 2008 SQL Server 2008 - General CTE and inner join RE: CTE and inner join

  • January 11, 2011 at 12:33 pm

    #1272034

    Yep. A CTE can be referenced multiple times inside of the statement immediately following it, but it can't be referenced by multiple statements within the query.

    you mean it can be used only once inside an inner join and that's all the problem?