Re: [SQL] comparing 2 tables. . .

Hello,

You can try this, (but i think it may take a long time )      1 : Find which tuples are in t1 and not in t2select
distinctt1.pk from t1 where t1.pk not in (select t2.pk from t2);      2 : Find which tuples are in t2 and not in
t1selectdistinct t2.pk from t2 where t2.pk not in (select t1.pk from t1);In the case that you only want to known the
references

If you want to rebuilt your table  after analyze you can make this :   select distinct t1.pk  into t1b from t1 where
t1.pknot in (select t2.pk
 
from t2);   select distinct t2.pk  into t2b from t2 where t2.pk not in (select t1.pk
from t1); After your analyze you can insert tuples of table t1b into table t1 and
tuples of table t2b into table t2.

Regards

--
Basier Eric  e-mail : basier@ipgp.jussieu.fr
http://geoscope.ipgp.jussieu.fr
IPGP Observatoires Sismologie-Volcanologie
4,Place Jussieu 75005 Paris Tour 24-14 4eme Etage Tel 01 44 27 38 96