# Is there a way to compare data between several tables in 2 schemas.

**URL:** <https://forums.toadworld.com/t/is-there-a-way-to-compare-data-between-several-tables-in-2-schemas/10109>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [December 15, 2010, 5:49pm UTC](https://forums.toadworld.com/t/is-there-a-way-to-compare-data-between-several-tables-in-2-schemas/10109 "2010-12-15T17:49:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Toad123](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/toad123/32/132_2.png) [@Toad123](https://forums.toadworld.com/u/Toad123)\
**Post date:** [December 15, 2010, 5:49pm UTC](https://forums.toadworld.com/t/is-there-a-way-to-compare-data-between-several-tables-in-2-schemas/10109/1 "2010-12-15T17:49:55Z")

</div>

It seems that Toad 9.7 version only compare between single table data in 2 schemas. Is it possible to compare between several tables at one time.

Thanks.

---

<div class="post-metadata">

**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\
**Post date:** [December 15, 2010, 5:49pm UTC](https://forums.toadworld.com/t/is-there-a-way-to-compare-data-between-several-tables-in-2-schemas/10109/2 "2010-12-15T17:49:55Z")

</div>

Toad for Data Analysts, which comes with Toad for Oracle is able to compare  
multiple pairs of tables, but it’s not 1:Many if that’s what you are  
asking.

More info here

[http://www.toadworld.com/BLOGS/tabid/67/EntryId/540/Toad-s-Most-Overlooked-Featur](http://www.toadworld.com/BLOGS/tabid/67/EntryId/540/Toad-s-Most-Overlooked-Featur)  
e.aspx