RightHandMan

I have 2 Seperate Databases, with Identical columns...
The data they have in common is the CustomerID #. One DB Has just customer Names and ID# the other has ID# and Order# / Date. I want to combine the two databases and all info so i end up with 1 database With ID#, NAME, ORDER#, and DATE. I dont want duplicate entries. How can i accomplish this???

__________________