On 29 November 2012 10:04, Imanuel wrote:
> SELECT c FROM mytable WHERE b IS NOT c
>
> Is this what you mean?
Or maybe she wants?
SELECT c FROM mytable WHERE c NOT IN (SELECT IFNULL(b,0) FROM mytable);
as in:
sqlite> CREATE TABLE mytable (b number, c number);
sqlite> INSERT INTO mytable VALUES(897313,897313);
sqlite> INSERT INTO mytable VALUES(854809,868763);
sqlite> INSERT INTO mytable VALUES(854808,854809);
sqlite> INSERT INTO mytable VALUES(NULL,854808);
sqlite> SELECT * FROM mytable;
897313|897313
854809|868763
854808|854809
|854808
sqlite> SELECT c FROM mytable WHERE c NOT IN (SELECT IFNULL(b,0)
FROM mytable);
868763
Regards,
Paul.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
