I have 2 tables.
I have table 1 which is data that comes in and table 3 which is data i have supplied already which is correct.
I need to compare the data to see if the same numbers exist in table 1 as the number in table 3.
if they do exist but have 0.00 or are empty( NULL)
Then must also be flagged up EVEN IF they are in both tables.
the query i have so far which display which number ARE IN table 3 but not table 1 is (ATTACHED)
I need to modify this query to be able to also fliter and push out mobile_numbers where the last_months_bill is 0.00 or NULL
Many thanks for your time.
LEFT JOIN table1 ON table3.MMobile_number = table1.EMobile_number
WHERE table1.EMobile_number IS NULL
OR table3.MMobile_number <> table1.EMobile_number";