I am trying to get a record set that does not include values that are considered blocked. Normally I would do this:
SELECT Value_1, Value_2, Value_3, Value_4, Value_5
FROM tbData
WHERE Value_1 NOT IN (SELECT Value_1 FROM tbBlockedValues)
The problem is, tbBlockedValues has 2 fields and it has...