Hi

I'm extracting some records and I want to exclude some of them from being extracted.

So I say

SELECT * from member 
where individual ref not in (select individual_ref from attribute where attribute.attr_code_ref = 1242 and individual_ref is not NULL and valid_to < getdate())

Is that the best way of doing this. ?

Thanks