List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:May 26 2003 2:59pm
Subject:Re: How to write this query pls?
View as plain text  
SELECT person.Id
FROM persons
LEFT JOIN phone USING ( id )
WHERE phone.id IS NULL AND phone.type = 'PHN'

PB

-----

  Thanks Edward,

  But that gives me ALL records in persons that have any ONE record in
phone.

  What I want is ONLY those records in persons that do NOT have a
  corresponding 'PHN' record in phone?

  Thanks again.


  -----Original Message-----
  From: Becoming Digital [mailto:subs@stripped]
  Sent: Monday, May 26, 2003 3:26 PM
  To: MySQL List
  Subject: Re: How to write this query pls?


  SELECT * FROM person, phone
  WHERE person.id = phone.id
  AND phone.type != 'PHN';

  Edward Dudlik
  Becoming Digital
  www.becomingdigital.com


  ----- Original Message -----
  From: "Titan 160" <titan160@stripped>
  To: <mysql@stripped>
  Sent: Monday, 26 May, 2003 04:42
  Subject: How to write this query pls?


  Hi,

  I'm not sure how to write this. Can you help pls?

  I have 2 tables

  persons & phone

  persons has a 1->M with phone on personID.

  phone can contain 3 'type' records relating to a person; 'EML', 'PHN',
'FAX'

  I want to select _only_ those records in person which do NOT have a 'type'
  'PHN' record in phone. Do I need a "NOT HAVING" or a "NOT IN" or...

  Basically I don't know how to write the WHERE section of the call.

  Can you help pls?


  [filter: SQL, MYSQL]




Thread
How to write this query pls?Titan 16026 May
  • Re: How to write this query pls?Becoming Digital26 May
    • RE: How to write this query pls?Titan 16026 May
      • Re: How to write this query pls?Becoming Digital26 May
        • Re: How to write this query pls?Aamir Baig26 May
          • RE: How to write this query pls?TheMechE26 May
            • Re: How to write this query pls?Aamir Baig27 May
              • Re: How to write this query pls?Dan Nelson27 May
            • Re: How to write this query pls?Peter Brawley27 May
      • Re: How to write this query pls?Peter Brawley26 May
RE: How to write this query pls?Titan 16026 May