Re: SELECT ... WHERE ... NOT IN (SELECT ...);

O, Yes...
The problem occure because of null from selecting into tbl2.
I have to delete record which eventid=null, and
the result become correct.

Pls be carefull with Null entri when using NOT IN.

Thanks for you all :-)

Regards,
-Yon-

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>Yon Den Baguse Ngarso <yon(at)dugem(dot)com> writes:
>> If i create tbl1 & tbl2, and then load it with the data.
>> The result is CORRECT. Like yours.
>> But, if the data loaded from another table, the result become WRONG/ null record.
>
>Do you have any nulls in what you are selecting into tbl2?
>The behavior of NOT IN with nulls is not very intuitive.
>
> regards, tom lane

_____________________________________________________________
Get yourname(at)dugem(dot)com at http://www.dugem.com

_____________________________________________________________
Promote your group and strengthen ties to your members with email(at)yourgroup(dot)org by Everyone.net http://www.everyone.net/?btn=tag