Posted by das on 05/19/06 21:36

Untested reply:

You would need 2 queries, first will be the same one that you have in
the select list, the other inner query will basically return you the
list of individuals who have the 'AC1' in their ATTRIB_DEF field.

select .... from ..
where individual not in (select disintct individual from ... where
ATTRIB_DEF like '%AC1%')

Hope that helps.

[Back to original message]