Re: efficient compare
From: -CELKO- <jcelko212_at_earthlink.net>
Date: 21 Apr 2006 09:56:03 -0700
Message-ID: <1145638563.747399.287680_at_v46g2000cwv.googlegroups.com>
Date: 21 Apr 2006 09:56:03 -0700
Message-ID: <1145638563.747399.287680_at_v46g2000cwv.googlegroups.com>
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 - 18:56:03 CEST