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?  
fernandowebAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor 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
 
DauheeConnect With a Mentor Commented:
create a view that joins the table and then just reference the view
0
 
fernandowebAuthor Commented:
Thanks for your help
0
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.

All Courses

From novice to tech pro — start learning today.