[SQL] Related table question

[Eric Forget]

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

Eric

___________________________________________________________________

 Eric Forget                       Cafederic
 ForgetE at cafederic.com             <http://www.cafederic.com/>

 Fingerprint <86D5 38F5 E1FD 5D9C 71C3  BAA3 797E 70A4 6210 C684>