> The query in IBExpert is acceptable.
> How do I check for statistics?

Move your eyes a little down and you'll see it on lower panel after
query run.

> How to query using ISQL?

Run isql, connect to database, issue the query.
If you can't reproduce the problem in isql - blame your application.

SY, SD.