Solved

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

Posted on 2008-06-24
3
788 Views
Last Modified: 2011-10-03
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
Comment
Question by:fernandoweb
3 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 125 total points
ID: 21855228
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
 
LVL 7

Assisted Solution

by:Dauhee
Dauhee earned 125 total points
ID: 21863774
create a view that joins the table and then just reference the view
0
 

Author Closing Comment

by:fernandoweb
ID: 31470118
Thanks for your help
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question