By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,660 Members | 1,557 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,660 IT Pros & Developers. It's quick & easy.

Combine Multiple Tables while deleting Multiples

P: 62
Hi,
I'm probably making this much harder than it needs to be, but I just can't think of how to do this. Each year, a database is created with all employees on it. I need to pull all the employees from the last five years and delete any duplicates. Each table has the exact same fields. So basically, I'm trying to combine tables from 2005, 2006, 2007, 2008 and 2009. Most of the employees will stay the same from year to year, so by combining all the years together, I get many multiples. There will be a few that aren't multiples, but how do I combine all this info and week out the multiples?
Aug 31 '09 #1

✓ answered by ajalwaysus

You should try a UNION Query, a union would allow you to union tables together and it would eliminate duplicates.

-AJ

Share this Question
Share on Google+
3 Replies


Expert 100+
P: 266
You should try a UNION Query, a union would allow you to union tables together and it would eliminate duplicates.

-AJ
Aug 31 '09 #2

P: 62
Duh...I knew I was making it harder than I needed to. Thanks for your help!!!
Aug 31 '09 #3

Expert 100+
P: 266
No problem. The easiest solutions are always the most elusive. =)

-AJ
Aug 31 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.