On 5/20/2013 7:59 AM, Paul Sanderson wrote:
I have a table of the formcreate table tab (num int1 unique, num2, int) for each row for num2 there is usually a matching num1. But not always. I want to identify each row where num2 does not have a matching num1
select * from tab where num2 not in (select num1 from tab); -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users