Upgrade to MySQL 4.1 and your nested query will run with no problem. But remember to change TOP 50 into LIMIT 50
Thanks Emery ----- Original Message ----- From: "Wajih-ur-Rehman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 23, 2003 12:40 Subject: nested select alternative?? > I have this statement that works perfectly fine in Access and MSSQL: (In > words, i first get the top 50 id values according to the where clause and > then i get the maximum of those id values) > > "SELECT Max(id) FROM (select top 50 id from myTable where infoId in > ( 3 ) AND id > 100 order by id ASC) AS t1 " > > (Note that id > 100 changes in every iteration of the loop in my code) > > I want to run a similar query in MYSQL....Is there *any* way to accomplish > it ? I have tried the following query without any luck > > "SELECT Max(id) FROM (select id from myTable where infoId in > ( 3 ) AND id > 100 order by id ASC LIMIT 50) AS t1 " > > > Thanx in advance > > Best Regards > Wajih > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
