That gave me the same results as the example I started with. I need to group by some type of sequence number when the status changes??

>>I have a query that I can't figure out. I need to list log delivery tickets (truck loads of trees) based on the number of tickets in a book and the min and max of the tickets that have been used and not used. Sounds simple so far. The problem is when the tickets are used out of order in the book. In a book of 25 tickets, if tickets 1,2,3,4 has been used, 5,6,7,8,9 has not been used, and 10,11,12 have been used, then I need the following list.
>>

>>Ticket book status    Min ticket   Max ticket
>>    1               Y        1                4
>>    1               N        5                9
>>    1               Y       10              12
>>    1               N       13              25             
>>

>>The query has the following list.
>>

>>select booknumber,status, min(ticket),max(ticket) from tickets
>>group by booknumber,status
>>
>>Ticket book status    Min ticket   Max ticket
>>    1               Y        1                12
>>    1               N        5                25
>>

>>
>>Any way to do this in a query?
>>
>>Thanks.
>
>Complex problem. I tried to think of a SQL solution and I guess you would need self-join of something like
>

>select T1.*, T2.* from Tickets T1 left Join Tickets T2 on T1.Book = T2.Book  and  T1.Status = T2.Status and T1.Ticket < T2.Ticket 
>

>See what results you get by this and if you can somehow proceed from it. If not, I would use procedural code - it seems pretty straightforward.