I am running MySql 4.1.22
I have two tables A and B.
A has a lot of customer data. ID is the key.
B has geocoded data that I enter in every day via a script (lat and long). ID is the key.
For each new customer in A, I insert geocoded data in B.
I need a query that will tell me what ID's in table A, DO NOT exist in Table B.
I can manage this now with some scripting and a few queries but I'm sure this can be done with just one query.
I have tried the query below in the code area but I keep getting zero result set. I am sure that table A has some ID's that do not yet exist in table B
SELECT A.ID FROM A,B WHERE A.ID=B.ID AND B.ID IS NULL;