Is this the right behavior?
CREATE TABLE t1(x INTEGER NOT NULL, y INTEGER); INSERT INTO t1(x, y) VALUES (1, 0); INSERT INTO t1(x, y) VALUES (2, 1); INSERT INTO t1(x, y) VALUES (3, NULL); sqlite> SELECT * FROM t1 A NATURAL JOIN t1 B; 1|0 2|1 I sense this could be right, but anyway... why isn't the null-row added to the result? Sure, NULL != NULL, but in this case it's the very same value in the database. Please enlighten me! Thanks _________________________________________________________________ Hitta kärleken nu i vår! http://dejting.se.msn.com/channel/index.aspx?trackingid=1002952 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users