We need a capability to have a custom key that derives from other table(s) other than the compared tables.
Comapre table A with table B.
table A table B table C
ln_nbr prop_nbr prop_nbr
... ... ln_nbr
ability to join table B and C to get the ln_nbr.
AdminDavid Atkinson (Admin, Redgate) commented
Can you create a view from the joined tables and compare the view to the table?