Re: Netsde Query

2002-06-25 Thread Victoria Reznichenko
harish, Thursday, June 20, 2002, 9:52:37 AM, you wrote: hv I am using mysql-4.0.1-alpha on windows 2000 professional hv How to exceute nested query in MySql hv select aeVcharEventId from alarmescalation where aeDtimeTimeStamp = (select hv max(aeDtimeTimeStamp) from alarmescalation) hv This

Netsde Query

2002-06-24 Thread harish . v
Hello everybody! I am using mysql-4.0.1-alpha on windows 2000 professional How to exceute nested query in MySql select aeVcharEventId from alarmescalation where aeDtimeTimeStamp = (select max(aeDtimeTimeStamp) from alarmescalation) This query gives an error you have an in your Sql syntax near

RE: Netsde Query

2002-06-24 Thread Cal Evans
you don't. Check the manual. Nested queries are not yet supported. (4.1?) =C= -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 1:53 AM To: [EMAIL PROTECTED] Subject: Netsde Query Hello everybody! I am using mysql-4.0.1-alpha