• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 794
  • Last Modified:

How do I append multiple tables without having to run an append query for each one?

Hi there.  I want to join together a group of tables (about 40 in total) which have mainly the same fields but at the moment am doing this by running an append query for each one on to one original table (which consequently grows in size each time).  Is there a better/quicker way I can do this?  
0
fernandoweb
Asked:
fernandoweb
2 Solutions
 
Rey Obrero (Capricorn1)Commented:
try using a union query

select * from T1
union all
select * from T2
union all
select * from T3
union all
select * from T4
union all
.
.

select * from T40
0
 
DauheeCommented:
create a view that joins the table and then just reference the view
0
 
fernandowebAuthor Commented:
Thanks for your help
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now