Re: efficient compare

>> ind out what is missing so that I can transfer whatever is needed from A to B and whatever is needed from B to A such that A=B. <<

Straight forward in Standard SQL.

BEGIN
INSERT INTO B
SELECT *
  FROM A EXCEPT B; INSERT INTO A
SELECT *
  FROM B EXCEPT A;
END; I am assuming that A and B are identical in structure (UNION compatible). But that leads to the question as to why there are two tables for one set of entities. Received on Fri Apr 21 2006 - 11:56:03 CDT