Merging 2 un-related tables - Help!

[TerryS]

Hi all. I have 2 unrelated tables that I need to merge into one new table. The problem is the tables are not related and there are same customers in both tables. The big problem is since there could be the same customer in both tables how to merge these into a single record (instead of having 2 separate records) and then merge this into the new table. I hope this makes sense.

Any guidance, advice, anything, would be greatly appreciated!
-Terry

 

[TheInsider]

Is this a one-time deal or do you have to develope a system to do this on an on-going basis? If it is a one-time process then you may be able to do something quick and dirty. Can you give me a list of fields in each table - hopefully any similar fields have the same type and size attributes. How many records are there?

Rob Marriott
rob@career-connections.net

 

[TerryS]

Thanks CCTC1. I *finally* got it figured out. Appreciate your response.