Toad World® Forums

Compare Data with Join


#1

I have two tables table A and B.

Table A have some plan information including ID and NAME of plan. PLAN_NAME is the unique value.

Table B have some rules configured for assignment of those plans and using plan Id. One plan can have many rules.

I have to compare the data in another database for same tables, but plan Id can be differ only PLAN_NAME is matching.

I am using Data Compare feature of Toad but not sure how to do this compare as I need to compare all plan rules for a PLAN_NAME…not sure if we can join in where clause while compare with Data compare featrure…or some other effective way available?