1. There are 2 tables T1 & T2 each with columns A1, B1, C1 and A2, B2, C2 respectively.
2. Need to match A1, B1, C1 with A2, B2, C2 respectively. If there is no match between them, then the query needs to fetch the results comparing C1 & C2.
Please let me know if this could be done. If yes, how?
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
Please explain how that query matches the A, B, and C columns. . . What i see refers to "not=" - where is the "match" . . . Then, there is the requirement that if A,B,C do not match, try for a match on C only.