I have three different queries that I want to do a UNION ALL with. The first and the second work together with UNION ALL. But the third doesn't. The column name are exact the same. BUT, the third one is using CTE. Anyone stumbled upon this issue before?

Can you share the query? I've gotten multiple UNION ALL to work selecting from CTE, but it looks like either all my queries either come from CTE or none do, I don't currently have any that do both.