At 19:37 18/02/2008 -0500, Igor Tandetnik wrote:
>What makes you feel the above is a non-standard solution? Or perhaps you
>mean it is, in your opinion, sub-standard?
I didn't say it was, but in books on SQL, they usually talk about joints,
hence my wondering if this were a more usual way of SEL
"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 (SEL
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
"Gilles Ganault" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> Since the syntax "WHERE phones_contact_tel not in contacts;" doesn't
> seem to exist
But this does:
where phones_contact_tel not in (select tel from contacts)
Igor Tandetnik
___
Hello
I have two tables:
- Phones, which has two columns: Tel and Name. A customer may have
more than one number
- Contacts, which has the expected colums (address, e-mail, etc.),
and, since phone numbers are unique, uses the main (or only) number
in Phones as primary key. IOW, to find a contac
5 matches
Mail list logo