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.