DECLARE @validIds;
SET @validIds = (SELECT id FROM clients WHERE VALID = 1);

IIF(@id IN @validIds, 1, 0)