Looks like it should work - thanks again, Serge

>Mike,
>
>Try

SELECT *
>	FROM mytable mt1
>	FULL OUTER JOIN mytable mt2
>		ON mt1.FldName = mt2.FldName
>	WHERE mt1.ItemCode = 1
>		AND mt2.ItemCode = 2 	
>		AND ( mt1.FldName IS NULL OR mt2.FldName IS NULL)
>

>>I have a table like this:
>>
>>

>>ItemCode   FldName
>>--------   -------
>>1          John
>>1          George
>>1          Ringo
>>2          John
>>2          Ringo
>>2          Paul
>>3          Bill
>>3          Bob
>>...
>>

>>
>>I would like to determin if there is ANY FldName with ItemCode 1 that does NOT have a matching FldName in item 2 - AND VICE VERSA.
>>
>>I was thinking of doing a SELECT FOR NOT IN - but I think I would have to do two statements to get the whole story. I suppose I could do some sort of an outer join, but I'm a bit baffled about how to do it in one step.