You need to make sure that your column sort order is the same in all of the unions. if each query works fine and it doesn't after applying the union, then probably your sort order for columns is different. for example:

select col1, col2, col3 from table1 union select col1, col2, col3 from table2

I hope this can fix your problem.