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 t2
select distinct t1.pk from t1 where t1.pk not in (select t2.pk from t2);
2 : Find which tuples are in t2 and not in t1
select distinct 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.pk not 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(at)ipgp(dot)jussieu(dot)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