ToffeeMark
New member
- Local time
- Today, 02:23
- Joined
- May 15, 2017
- Messages
- 9
Hi, This might be a really basic question, I don't do much in SQL, tend to mainly use the design mode.
I get verylarge monthly data tables in which every row has a period identifier e.g. 201705.
All the monthly tables are separate.201507, 201506 etc
I've linked them into my database.
Can a query pull out data from all the different month tables and perform a make table (or select) into one table?
Or do I have to query each one separately and then append together. Or append all the months into one humongous table and then query that...
Any help on how you would tackle this problem or what I should read up on would be gratefully received.
Thanks
Mark
I get verylarge monthly data tables in which every row has a period identifier e.g. 201705.
All the monthly tables are separate.201507, 201506 etc
I've linked them into my database.
Can a query pull out data from all the different month tables and perform a make table (or select) into one table?
Or do I have to query each one separately and then append together. Or append all the months into one humongous table and then query that...
Any help on how you would tackle this problem or what I should read up on would be gratefully received.
Thanks
Mark