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.
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site