@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
Hello Michael. Here is the query you wanted - you were almost there.
SELECT DISTINCT NAME FROM PEOPLE
WHERE ID IN
(SELECT PID FROM PEOPLE_CITY_MAP
WHERE CID = 1)
Thanks.
-Original Message-
From: Michael Fischer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 31, 2007 11:53
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;
+---+
