Information générale
Catégorie:
Codage, syntaxe et commandes
Hi,
May try SQL, e.g. select * from tableb where fd1+fd2+fd3 not in;
(select fd1+fd2+fd3 from tablea) into cursor new_recs
Then append it from the cursor. But if there are many fields with different data types then it may not be a good idea.
With Oracle, it'd be better, insert into tablea select * from tableb;
where (fd1,fd2,fd3) not in (select fd1,fd....)
Wilfred
>Hi All,
> I have one table (table A) that has the data I want to compare with another table (table B). I was thinking of using the scatter memvar command in table A and scanning through table B. If there were records that I had missed or were unique I would append them into table A from table B. Has anyone done this before? Is there a better way to compare data in two tables?
>Thanks,
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement