I've had the same problem once.
Reading the manual I found out that MySQL is not SQL conform
and does not support sub-selects.
You'll have to rewrite the statement that you don't need a sub-select
or if not possible create a temporary table.
Regards,
Robert
- Original Message -
From: "B
As I understand it, you can only list distinct values in an IN clause -
MySQL doesn't yet support subqueries here - according to the manual.See
page 139 of the pdf manual.
-Original Message-
From: Bobby Chopra [mailto:[EMAIL PROTECTED]]
Sent: Thu, 26 April 2001 14:10
To: [EMAIL PROTEC
