comparing from two different DBs

[gaurab]

Hiee e'body,

I hav a situation, I have to compare the fields two different tables of of two databases.

say ,

A and B are two DBs.

AA and BB are two different tables in those respective DBs.
and AA1 , AA2 , AA3 are the fields of the table AA which i have to compare with BB1, BB2 , BB3 of the table BB to check whether they are same or not. And if the all values of the fields dont exist in BB I have to assign them to BB from AA.


could anybody help me with the code which i have to write in procedure editor once both the DBs are connected.

any kind of help appriciated.... thanks in advance...PLZ:blush1:


Gaurab

 

[bulklodd]

Look at BUFFER-COMPARE I think it's what you're looking for. BUFFER-COMPARE compares two records from different tables including tables from different bases.