[SQL] Related table question

[Ruslan Zasukhin]

on 1/18/04 9:23 AM, Eric Forget at forgete at cafederic.com wrote:

>>   b) For inequality:
>> 
>>           a.RecID not in (select ptr from keyword where name <> 'Me')
>> 
>> 
>> However, I see b) working without understanding it. For me it looks like a
>> double negation. Maybe there is something about SQL I don't understand.
> 
> After doing more testing, I realized that both
> 
>   a.RecID not in (select ptr from keyword where name <> 'Me')
> 
> and
> 
>   a.RecID not in (select ptr from keyword where name = 'Me')
> 
> always give the same result!

Okay, then try syntax:


   not( a.RecID in (select ptr from keyword where name = 'Me'))
    


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------