Combining Tables

[Adam]

I have 12 tables with 12 months of data. The fields names in each table are
exactly the same (incident number, date, etc.), with the data in each table
representing a month of data. How do I combine these 12 tables into one
table?

 

[Ben]

do a UNION query:

select * from tbl1
UNION
select * from tbl2
....
UNION
select * from tb12

Note: Union queries automatically removes the dups from all the tables.


Ben

 

[RonaldoOneNil]

Why do you need to combine into 1 table ?
Create a union query which selects the data from the 12 tables.
SELECT * FROM [TableNameforMonth1];
UNION ALL SELECT * FROM [TableNameforMonth2];
UNION ALL SELECT * FROM [TableNameforMonth3];
etc.

 

[KARL DEWEY]

You might want it like this --
SELECT *, 1 AS Month_All FROM [TableNameforMonth1]
UNION ALL SELECT *, 2 AS Month_All FROM [TableNameforMonth2]
UNION ALL SELECT *, 3 AS Month_All FROM [TableNameforMonth3]
......
UNION ALL SELECT *, 12 AS Month_All FROM [TableNameforMonth12];

--
KARL DEWEY
Build a little - Test a little

Why do you need to combine into 1 table ?
Create a union query which selects the data from the 12 tables.
SELECT * FROM [TableNameforMonth1];
UNION ALL SELECT * FROM [TableNameforMonth2];
UNION ALL SELECT * FROM [TableNameforMonth3];
etc.

I have 12 tables with 12 months of data. The fields names in each table are
exactly the same (incident number, date, etc.), with the data in each table
representing a month of data. How do I combine these 12 tables into one
table?