That might explain it:-) The really said part is I remember running into the same issue some months back and completely forgot.
Thanks -----Original Message----- From: Dan Nelson [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 25, 2005 6:54 PM To: Bartis, Robert M (Bob) Cc: 'mysql' 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. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
