I was curious if a subquery could handle this, assuming that this
I need to determine all locations where service type 3 doesn't exist for them.
means if a location has a value, omit all of those locations and that there won't be a set number of location records for a type. This seems to work:
Code:
SELECT tbl1.Fld1 FROM tbl1
WHERE (((tbl1.Fld1) Not In (SELECT tbl1.[Fld1] FROM tbl1 WHERE tbl1.FldValue = 3)))
ORDER BY tbl1.Fld1;
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.