Hi,

I am trying to join (say) 5 tables that each have the SAME columns but DIFFERENT data, and I want it all in a single table. There is NO overlap in data- each row is the details about a single computer in my fleet.

What's the best way to join these tables please?

Summary- I have a whole bunch of tables from different physical sites with basically the same information in them. I want to create a 'super table' with all the data, and without trying to match/add/delete anything except the column names....