Hi,

> Thanks but it doesn't seem to work fast enough. So I keep to the

other

> suggestions.
>
> It seems like firebird prefers joins made with explicitely use of

join

> rather than the implicit call in my code and the code above.
>

Yup, my goal was not about show fastest.
i wanted to give you some performance triks about FB.
If a simple query takes some hours, it mean there is index problem
or too many re-reads over data or index pages.

Regards.
Ali