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
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
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
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