Re: Best way to compare contents of two tables?

Try
select * from tab1
minus
select * from tab2;
it should return 0 rows

        Gert

-- 
At Home: gem_at_wirehub.nl
At Work: gert.rijs_at_corp.ah.nl

The Mailman <defili66_at_futures.wharton.upenn.edu> wrote in article
<5c2q94$4ud_at_netnews.upenn.edu>...


> What is the best way to compare the contents of two tables to ensure that




> their data exactly reflects each other?

> 

> Thanks for any info regarding this topic.

> 

> Joe

>