Hi again,

i'm just tested your problem with my huge tables
and not found any weird things...

works perfectly at ultra speed.
(ibexpert fetchs about 5000 rows in a second on my poor laptop)


select * from muracaat mr
join hasta hs on ( hs.id = mr.hasta_id and hs.cinsiyeti='E' )
where
mr.id>500000

Regards.

Ali