Re: Searching for SQL Script to compare tables

From: Don Fraser <don_at_clear.net.nz>
Date: 1998/02/16
Message-ID: <6c7hu5$8ca$1_at_fep4.clear.net.nz>#1/1


Raj Gabriƫlse wrote in message <34E6DC18.2304CD02_at_ctbede.nl>...
>Hi all,
>
>I'm looking for a script that can compare two tables to each other and
>list the differences.

Use the minus command

select all rows from table1
MINUS
select all rows from table2 Received on Mon Feb 16 1998 - 00:00:00 CET

Original text of this message