[SQL] Related table question

[Ruslan Zasukhin]

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

>>> 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'))
> 
> This seems to give more reliable results...

Okay,   NOT( EXPR ) works always.

-- 
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
-------------------------------------------------------------