Re: comparing 3 tables from 3 databases

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Wed, 11 Aug 2004 00:46:46 GMT
Message-ID: <Xns9541B4DD0C7FFSunnySD@68.6.19.6>

"Shawn" <spedwards_at_x.qwest.net> wrote in news:4HbSc.13$ah5.102082_at_news.uswest.net:

> We have 3 databases. Each of these databases have a identical table.
> Each table has anywhere from
> 1400-1550 records. The data in these tables was supposed to be
> identical. But they aren't.
> So, I need to compare the table in each database to determine the
> exact differences of the data.
> Any suggestions on how to best complete this task would be greatly
> appreciated!
>
> Thanks,
> Shawn
>

SELECT * FROM TABLE_A
MINUS
SELECT * FROM TABLE_A_at_REMOTE1; ETC., ETC., ETC. Received on Tue Aug 10 2004 - 19:46:46 CDT