I have 3 files I want to combine:
Table x with Field 1, field 2 and field 3
Tab;e y with Field 1, field 4 and field 5
table z with field 2, field 6 and field 7
how do I create a union query to get them all together:
Select Field 1, field 2, field 3....field 7 from x
How do I pad the tables with no fields so I don't get a parameter pop up.
Table x with Field 1, field 2 and field 3
Tab;e y with Field 1, field 4 and field 5
table z with field 2, field 6 and field 7
how do I create a union query to get them all together:
Select Field 1, field 2, field 3....field 7 from x
How do I pad the tables with no fields so I don't get a parameter pop up.