Union all error must have equal number of expressions

Question

I am trying to run this query but I am getting this error:

All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.

What am I doing wrong here? Please help.

SELECT      *
into       #xx 
From (
Select *
FROM #x 
union all  
select * from MartDB.DBO.BAW_AllSources_Stage1
) AAAsds

Answer 1

Your inner query part

Select *
FROM        #x 
union all  
select * 
from MartDB.DBO.BAW_AllSources_Stage1

has * in both queries participating in UNION.

Check and see if the both *s translate into same number of columns and data type in order.