• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 796
  • 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?  
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
create a view that joins the table and then just reference the view
fernandowebAuthor Commented:
Thanks for your help
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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