I once knew how to do this but cannot recall nor can I find on this forum but maybe I am wording it badly.
I have a Customer table and a Machinetable related by CustomerID.
I want to find using SQL, all customers that do not have ANY machines
Have tried this in Data Viewer and get ?
LEFT JOIN Machine ON Customer.AccNo= Machine."_AccNo"
Machine.Model IS null
Hope someone can put me straight on this.