Posted by roberthornsby on 12/13/06 13:09

Hi,
Please can you help me with this query which I am struggling with?
Here is a simplified version of the table I am trying to work with

VehicleId, PurchaseId, PurchaseDate, Comment

1, 1, 03/03/2006, 'customer has a big nose'
1, 79, 04/04/2006, 'it's raining'
1, 8, 05/05/2006, 'man, i keep selling this vehicle'
2, 412, 02/02/2006, 'I break for lunch in 10 minutes'
2, 5, 03/03/2006, 'I wonder what's on TV tonight'
3, 2, 05/05/2006, 'I am the angel of death, destroyer of worlds'

I need to select only the rows for the first time the vehicle is sold
(specifically I need the comment). I need to return

1, 1, 03/03/2006, 'customer has a big nose'
2, 412, 02/02/2006, 'I break for lunch in 10 minutes'
3, 2, 05/05/2006, 'I am the angel of death, destroyer of worlds'

Purchase Id cannot be guaranteed to be in ascending date order.

Can anyone help please?
Thanks
Rob

[Back to original message]