Best way I can think of:

select top 50 * from table order by something DESC

then:

movelast

do while not bof
    process it
    moveprev
loop

Ian

--------------------------------------------
Ian Bambury
eCommerce Project Manager
JAS Worldwide

ibambury@j...
www.jasww.com
--------------------------------------------
----- Original Message -----
From: "Gavin Wu" <gavin@m...>
To: "professional vb" <pro_vb@p...>
Sent: Saturday, October 19, 2002 3:03 PM
Subject: [pro_vb] RE: SQL Query with Last 50 Records


> I do not think you can make it unless you have identity or datetime field.
>
>
> -----Original Message-----
> From: Dr. Niaz Mohammed [mailto:mniaz@k...]
> Sent: Saturday, October 19, 2002 11:17 AM
> To: professional vb
> Subject: [pro_vb] SQL Query with Last 50 Records
>
> I have a SQL query that joins 3 Tables from the SQL Server. What is the
> easiest way to set the joining condition for one Table as the Last (latest
> by insertion) 50 Records. I do not have any Identity Column for the Table.
>
> Thanks in adavance
>
>
>
>
> ---
> Visual C# - A Guide for VB6 Developers
> This book will make it easy to transfer your skills
> from Visual Basic 6 to C#, the language of choice
> of the .NET Framework.
> http://www.wrox.com/ACON11.asp?ISBN=1861007175&p2p0059
>
>
>
> ---
> Visual C# - A Guide for VB6 Developers
> This book will make it easy to transfer your skills
> from Visual Basic 6 to C#, the language of choice
> of the .NET Framework.
> http://www.wrox.com/ACON11.asp?ISBN=1861007175&p2p0059
>