> There are two ways to rewrite this query, with a correlated subquery: > > SELECT * > FROM table_a AS x > WHERE NOT EXISTS (SELECT 1 > FROM table_b AS y > WHERE x.id = y.id > AND x.col = y.col) > > or with an outer join: > > SELECT x.* > FROM table_a AS x > LEFT JOIN table_b AS y USING (id, col) > WHERE y.id IS NULL
Hi Clemens, Totally missed the boat on those two. Much appreciated, jlc _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
