>I'd like to pull some data where status is equal to "T" for terminated and not in a list where there might also be one type of active coverage for the same insured person where status="A". There are different types of insurance coverages.
>
>I don't see how I can do a WHERE NOT IN, although there is NOT INLIST(), but that doesn't seem to fit.
>
>Any ideas?
>
>Cecil

Can you post the command where WHERE (search term) NOT IN (subselect SQL command) does not work? It should.