That might explain it:-) The really said part is I remember running into the same issue
some months back and completely forgot.
From: Dan Nelson [mailto:dnelson@stripped]
Sent: Wednesday, May 25, 2005 6:54 PM
To: Bartis, Robert M (Bob)
Subject: Re: Subquery question
In the last episode (May 25), Bartis, Robert M (Bob) said:
> Apologize for not including the error:
> You have an error in your SQL syntax. Check the manual that corresponds to your
> MySQL server version for the right syntax to use near 'SELECT plantriggers.ID FROM
> plantriggers WHERE (((plantrigger
> I'm running MySQL 4.0.2-standard
4.0 doesn't support subqueries. You'll need to upgrade to 4.1.