maybe something like
select *
from invoice
where status = 1 and statusdate = max(statusdate)
group by invoiceID
This is off the top of my head so I don't know the real table and
column names but that's the idea.....
On 12 Jul 2000, at 0:33, Tom Jakobsen wrote:
> Hi
>
> Any1 knows how to query the database to only
> list orders that has order status 1 as its last status.
>
> Thanks
>
> Tom
>
>
>
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Site: http://www.working-dogs.com/freetrade/
> Problems?: [EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
