RE: INSERT WHERE NOT EXISTS syntax

2008-01-23 Thread roger.maynard
I think I sorted it out ... INSERT INTO master_comments (comment_no,comment_text,language_id) SELECT comment_no,comment_text,language_id from mComments WHERE NOT EXISTS ( SELECT comment_no FROM master_comments WHERE mComments.comment_no = master_comments.comment_no ); Hope this helps someone

INSERT WHERE NOT EXISTS syntax

2008-01-23 Thread roger.maynard
Can anyone tell me why this isn't working... v5.0 INSERT INTO master_comments (comment_no,comment_text,language_id) SELECT comment_no,comment_text,language_id from mComments WHERE NOT EXISTS (SELECT comment_no FROM master_comments); I thought I had it working once but now it

RE: WHERE (NOT) EXISTS problem

2007-02-01 Thread Price, Randall
@lists.mysql.com Subject: Re: WHERE (NOT) EXISTS problem Michael Fischer wrote: > Having a very bad time with the subject sorts of queries. > Here is a simple reproduction of the problem for me. > Perhaps I'm blind/stupid while looking at the docs, > or there's a bug... > > m

RE: WHERE (NOT) EXISTS problem

2007-02-01 Thread Brown, Charles
PM To: mysql@lists.mysql.com Subject: WHERE (NOT) EXISTS problem Having a very bad time with the subject sorts of queries. Here is a simple reproduction of the problem for me. Perhaps I'm blind/stupid while looking at the docs, or there's a bug... mysql version 5.0.24-standard sim

Re: WHERE (NOT) EXISTS problem

2007-01-31 Thread Chris
Michael Fischer wrote: Having a very bad time with the subject sorts of queries. Here is a simple reproduction of the problem for me. Perhaps I'm blind/stupid while looking at the docs, or there's a bug... mysql version 5.0.24-standard simple schema: mysql> desc people; +---+

WHERE (NOT) EXISTS problem

2007-01-31 Thread Michael Fischer
Having a very bad time with the subject sorts of queries. Here is a simple reproduction of the problem for me. Perhaps I'm blind/stupid while looking at the docs, or there's a bug... mysql version 5.0.24-standard simple schema: mysql> desc people; +---+--+--+-+

Re: WHERE NOT EXISTS

2004-02-09 Thread Michael Satterwhite
all class_name from classes that aren't > represented a specific year. > > So what I want as result is HD, DD, MD > I'm trying to use the following query: > > SELECT class_name FROM classes WHERE NOT EXISTS (SELECT * FROM champions > WHERE champions.class_name=classes.

Re: WHERE NOT EXISTS

2004-02-09 Thread Victoria Reznichenko
D, DD, MD > > I'm trying to use the following query: > > > SELECT class_name FROM classes WHERE NOT EXISTS (SELECT * FROM champions WHERE > champions.class_name=classes.class_name AND champions.year='1981') > > > ERRORREPORT: > > #1064 - You have an

Re: WHERE NOT EXISTS

2004-02-09 Thread AllesKunst.net ID GesmbH
- Original Message - From: "Carl Schéle, IT, Posten" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 09, 2004 3:05 PM Subject: WHERE NOT EXISTS I use php 4.1.1. mysql 3.23.49 and phpmyadmin 2.5.4 I have

WHERE NOT EXISTS

2004-02-09 Thread "Carl Schéle, IT, Posten"
) 1981 HS PETER 1981 DS ANNE What I want to do is to list all class_name from classes that aren't represented a specific year. So what I want as result is HD, DD, MD I'm trying to use the following query: SELECT class_name FROM classes WHERE NOT EXIS

'where not exists' problem

2002-01-29 Thread Victoria Reznichenko
Jessica, Monday, January 28, 2002, 3:13:11 PM, you wrote: JR> Can anyone help me - JR> I am trying to extract data on the availability of a holiday villa using the JR> statement JR> 'SELECT PossDate from JuneDates where not exists(SELECT PossDate FROM JR> Reservation WH

'where not exists' problem

2002-01-28 Thread Jessica Richardson
Can anyone help me - I am trying to extract data on the availability of a holiday villa using the statement 'SELECT PossDate from JuneDates where not exists(SELECT PossDate FROM Reservation WHERE PossDate Between ArrDate And DeptDate AND Reservation.VillaID=\'Adonis\')'.