Re: table comparison

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 4 Nov 1999 18:06:25 +0100
Message-ID: <7vseh8$glj$1@oceanite.cybercable.fr>

Try:
select * from table1 minus select * from table2; and
select * from table2 minus select * from table1;

The first one gives all the records in table1 that are not in table2 and the second one the opposite.

--
Have a nice day
Michel

Nandakumar <N.Kumar_at_rocketmail.com> a écrit dans le message : 7vsd6h$5m$1_at_nnrp1.deja.com...
> Hi
>
> Are there any tools to compare two indentical tables for the data they
> contain?
> i need it just to make sure one table is in sync. with another.
>
> about the tables, they are really huge, have about 20 fields, do not
> have primary key or unique fields;
>
> thanks in advance for your responses!
> --
> Nandakumar
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Nov 04 1999 - 11:06:25 CST