The used SELECT statements have a different number of columns

Put the columns names explicitly rather than *, and make sure the number of columns and data types match for the same column in each select.

Update:

I really don’t think you want to be UNIONing those tables, based on the tables names. They don’t seem to contain related data. If you post your schema and describe what you are trying to achieve it is likely we can provide better help.

Leave a Comment