Do fields have to be in the same order for a union?

[kestefon]

Hi Everyone,



I have some tables with identical field names, but the fields are in a different order. Is it possible to do a union like this, or do I have to rearrange the data within each table first?

For instance:

Table A: Field1, Field4, Field2, Field3
Table B: Field3, Field1, Field4, Field2
Table C: Field2, Field3, Field1, Field4

And I'm trying to combine those tables into TableABC: Field1, Field2, Field3, Field4.

[June7]

Can do that and the data will appear in the columns in that order. If fields are not same datatype the query could error. The first line defines datatype and field names.

So unless you want Field1 data from Table A to mix with Field3 from Table B and Field2 from TableC, list fields in the same order.

[kestefon]

Thanks. So, I will definitely have to rearrange each table's fields before attempting a UNION? I want to confirm that there's no way around it...

[June7]

Sorry, I didn't explain that very well.

The table order can be ignored if the fields are explicitly listed in the UNION query.