I have a table where I have marked a yes/no with true. for each Vin field group i want to delete the false records but not sure how to construct the query.
one thing if the vin field has all false then leave as is
see attached, this says in the example given that the vin has colour match to blue so therefore it cannot be any of the others. ee.JPG