"Gilles Ganault" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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?
What makes you feel the above is a non-standard solution? Or perhaps you mean it is, in your opinion, sub-standard? Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
