> ...OK, almost beaten. Try the following as well - just to be sure (I would
> be very surprised if this helped much):
> JOIN ROOMSTAT R1 ON R1.TERMINAL = C1.ROOM
> WHERE C1.TICKET_REF BETWEEN :FROMD AND :TOD

Well still in the 60's, possibly a little faster, but that
is probably just W2k being busy.

I'm quite happy with the 4 query solution, but this is
obviously an area within Firebird that is worth a look at!

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services