Check for Unmatched record

Ihussein

Registered User.
Local time
Today, 03:04
Joined
Nov 11, 2015
Messages
47
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 From - To in table (B). I don't what to go for the solution of generating in between serials of Table (B).
Regards
 
Last edited:
You should be able to accomplish this with a SQL query
Code:
SELECT TableA.*
FROM TableA LEFT JOIN TableB ON TableA.LinkField = TableB.LinkField
WHERE TableB.UniqueID IS NULL
 
I tried but it's does n't work, I'm attached the image of the two tables, hope it's self explanatory.
Regards
 
Table%28A%29%26%28B%29.JPG
 

Users who are viewing this thread

Back
Top Bottom