nested select alternative??

2003-09-23 Thread Wajih-ur-Rehman
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

Re: nested select alternative??

2003-09-23 Thread Victoria Reznichenko
Wajih-ur-Rehman [EMAIL PROTECTED] wrote: 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

Re: nested select alternative??

2003-09-23 Thread Haydies
PROTECTED] Sent: Tuesday, September 23, 2003 2:41 PM Subject: Re: nested select alternative?? : Wajih-ur-Rehman [EMAIL PROTECTED] wrote: : 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

Re: nested select alternative??

2003-09-23 Thread Director General: NEFACOMP
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