Re: [SQL] 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 <[EMAIL PROTECTED]> wrote: >Yon Den Baguse Nga

Re: [SQL] SELECT ... WHERE ... NOT IN (SELECT ...);

I use a 7.3devel recently build (on a FreeBSD 4.3 box) from CVS sources. I follow all your steps, and psql results : test_db=> \! cat problem.sql --create new temp tbl1 SELECT losteventid AS eventid INTO tbl1 FROM outages; --create new temp tbl2 SELECT regainedeventid AS eventid INTO tbl2 FROM o