On Mon, 18 Feb 2008 15:03:27 -0500, "Igor Tandetnik" <[EMAIL PROTECTED]> wrote: >where phones_contact_tel not in (select tel from contacts)
Thanks, it worked: SELECT * FROM phones WHERE phones_tel NOT IN (SELECT contacts_phones_tel FROM contacts); Out of curiosity, isn't the standard solution to use JOIN instead of a sub-SELECT? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
