I have two tables that I want to check is there any record in Table (A) but not in Table (B) the comparison column is number field, my problem is that the numbers are in serial in the first column while scattered into two columns in table (B). I don't what to go for the solution of generating in between serials of Table (B).
hope the attached image is self explanatory. Regards