@Anonymous You can create a Composite Key with all the matching columns in both tables.
For Example Column's in Tables 1 & 2
t1.A, t1.B, t1.C, t1.J t2.A, t2.B, t2.C, t2.D, t2.R, t2.J
with Composite Key Data { Both table have: ABCJ}
t1.A, t1.B, t1.C, t1.J, t1ABCJ
t2.A, t2.B, t2.C, t2.D, t2.R, t2.J, t2ABCJ
Join on the Composite Key.
Let me know if this works for you, or share a sample data.
@ me in replies, or I'll lose your thread!!!
Do my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!
Best Regards,
Dallas.
