Query:Earliest DeliveryDate

[Rattlesnake]

Hi ,
In Sql Server 2000 I have a Log table "Logs" that conatins the fields
1. OrderNo
2. SequenceID


There is another table "Sequences" , that has the fields
1. SequenceID
2. DeliveryDate

In the Log table there can be multiple records for an Order with different SequenceID.
e.g.

OrderNo : SequenceID
_______ :___________
1 : 5
1 : 10
1 : 15
2 : 6
3 : 11
3 : 18

And the Sequences table is e.g.

SequenceID : DeliveryDate
__________ : ____________
5 : 02/01/2007
6 : 02/05/2007
10 : 02/10/2007
11 : 02/12/2007
15 : 02/13/2007
18 : 02/16/2007



Now each SequenceID corresponds to a DeliveryDate from the Sequences tabele


I want to create a query that will give me the Min(DeliveryDate) for each Order along with the corresponding SeqeunceID

So basically I want to know the earliest delivery date for an Order and the SequenceID to which this earliest delivery date corresponds to.


What will be the Query for this ???

Thanks