From: Dan Nelson
Date: May 25 2005 10:53pm
Subject: Re: Subquery question
List-Archive: http://lists.mysql.com/mysql/184602
Message-Id: <20050525225346.GC87847@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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