Re: [PHP-WIN] SQL to select a set of records

[Stuart]

David Felton wrote:
SELECT TOP 10 dbo.Table_MIS_Files.File_ID
FROM		dbo.Table_MIS_Files
WHERE     dbo.Table_MIS_Files.File_ID NOT IN 
(SELECT TOP 25 dbo.Table_MIS_Files.File_ID
FROM		dbo.Table_MIS_Files)
Shouldn't this be...

SELECT TOP 25 dbo.Table_MIS_Files.File_ID
FROM            dbo.Table_MIS_Files
WHERE     dbo.Table_MIS_Files.File_ID NOT IN
(SELECT TOP 10 dbo.Table_MIS_Files.File_ID
FROM            dbo.Table_MIS_Files)
That will get rows 11-25.
--
Stuart
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php