MySQL doen not yet support nested queries.
Jawad Khan wrote:
> server version 3.23.35
>> -----Original Message-----
>> From: Khan, Jawad [COLE:6S34:EXCH]
>> Sent: Thursday, June 28, 2001 1:13 PM
>> To: 'mysql@stripped'
>> Subject: I get SYNTAX ERROR 1064 with mySQL 3.2.3 when using delete
>> as shown
>> Hope you can find the problem in the following SQL command:
>> delete from alarms where raiseTime = ( select MIN(raiseTime) from alarms)
>> limit 1 ;
>> raiseTime is of type BIGINT.
Gerald L. Clark