General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only