Re: comparing 3 tables from 3 databases

> > > 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;
>
> I'd extend that to
>
> select * from
> (SELECT * FROM TABLE_A
> MINUS
> SELECT * FROM TABLE_A_at_REMOTE1)
> union
> (SELECT * FROM TABLE_A_at_REMOTE1
> MINUS
> SELECT * FROM TABLE_A)
>
> etc
>
> and we are both assuming that the table *definitions* are the same but the
> data is different.
>
> --

What if the databases aren't linked? Each database represents separate/distinct financial activity and I think they keep them apart for audit reasons?

Thanks,
Shawn Received on Wed Aug 11 2004 - 17:22:30 CDT