List:General Discussion« Previous MessageNext Message »
From:Robert M (Bob) Bartis Date:May 25 2005 10:55pm
Subject:RE: Subquery question
View as plain text  
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:dnelson@stripped]
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
	dnelson@stripped
Thread
Subquery questionBob)26 May
RE: Subquery questionBob)26 May
  • Re: Subquery questionDan Nelson26 May
RE: Subquery questionBob)26 May