merging tables
Posted by:
John M
Date: April 21, 2010 07:48AM
I have two identical client tables , clients1 and clients2.
I want to merge these tables cause clients1 has more records than clients2.
I don't want duplicates so the field `PHONE1` is the one that every client record has as unique from each other. The primary key though on both is the auto increment `ID` field.
I'm trying to find a query but it seems that i'm doing something wrong here. So any advise would be really appreciated.
Thank in advance..
Subject
Written By
Posted
merging tables
April 21, 2010 07:48AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.