[SQL] Related table question

[Eric Forget]

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

Eric

___________________________________________________________________

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

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