all queries combined using a union, intersect or except operator must have an equal number of expressions in their target lists. sql-server-performance.com Category:programming and developer software Global Rank:2,978,188 visits:12.8K pages/Per:1.3 ADS