Hi guys - I'm new to the forums so I'm not sure where this query lives.
So I need to append/union maybe 60 tables. I realise that I can use union/union all to do this task. However as you know - this only works if all tables have the same structure (i.e. same number of fields and field names are identical).
The problem is that my tables are very wide and although they all share a lot of the same fields as each other - there are quite a lot of fields that are unique to certain tables.
Therefore union/union all will not work.
I understand that I can use dummy fields (or null fields) to match up table structure so a union/union all could be used - I really do not want to do this due to the amount of time it would take to make this work.
Is there another solution?
For those who know SAS - the following statement would work but is there an SQL alternative?
set table1 table2 table3 .... table60
Hope this is enough information - any help would be great.