On May 27, 2008, at 3:21 PM, Gilles Ganault wrote: > I have two tables, and I'd like to SELECT rows from table1 where an > item it not in table2
Something along these lines: select table1.* from table1 left join table2 on table2.employee = table1.employee ... where table2.employee is null -- PA. http://alt.textdrive.com/nanoki/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
