@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
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
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;
+---+
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;
+---+--+--+-+
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 Arr
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 do
