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?