Sign in to follow this  

Access 2000

Recommended Posts

I am writing a query in SQL to produce the union of 2 tables like this...



SELECT [100].*FROM [100]UNION SELECT [300].*FROM [300];



[100] and [300] are the table names. I have 10 tables or so and I want to perform the union on all 10 at the same time to remove any duplicated data between the tables. How to I do this? Anyone with some SQL experience?



Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.