Search code examples
sqlsql-serverexcept

sql select column from except result

I try to get column from except result, but all the time have error "Incorect syntax near ')'" even when I put Select * in first select. I work on SQL Management Studio. My code looks like 

select ColumnResult from (
            select col1 as ColumnResult, col2 as Column2Result, col3 as Column3Result
            from SourceTable 
            except
            select col1 as ColumnResult, col2 as Column2Result, col3 as Column3Result
            from SourceTable2)
Solution

  • You need to give you subquery an alias:

    select ColumnResult from (
            select col1 as ColumnResult, col2 as Column2Result, col3 as Column3Result
            from SourceTable 
            except
            select col1 as ColumnResult, col2 as Column2Result, col3 as Column3Result
            from SourceTable2) AS Src