| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Titan 160 | Date: | May 26 2003 8:42am |
| Subject: | How to write this query pls? | ||
| View as plain text | |||
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 160 | 26 May |
| • Re: How to write this query pls? | Becoming Digital | 26 May |
| • RE: How to write this query pls? | Titan 160 | 26 May |
| • Re: How to write this query pls? | Becoming Digital | 26 May |
| • Re: How to write this query pls? | Aamir Baig | 26 May |
| • RE: How to write this query pls? | TheMechE | 26 May |
| • Re: How to write this query pls? | Aamir Baig | 27 May |
| • Re: How to write this query pls? | Dan Nelson | 27 May |
| • Re: How to write this query pls? | Peter Brawley | 27 May |
| • Re: How to write this query pls? | Peter Brawley | 26 May |
| • RE: How to write this query pls? | Titan 160 | 26 May |
