RE: WHERE (NOT) EXISTS problem

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 simple schema

RE: WHERE (NOT) EXISTS problem

@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... mysql version 5.0.24-standard simple

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 simple schema: mysql desc people;

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... mysql version 5.0.24-standard simple schema: mysql desc people;

'where not exists' problem

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 WHERE PossDate Between ArrDate

'where not exists' problem

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\')'. (This was originally