I have a table of the form create 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 example data might be num1 num2 1 3 2 3 3 2 4 1 5 11 6 3 7 9 in this example my query would return rows 5 and 7 as there is no match on num1 for 11 and 9 Any ideas, cheers. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users