>>It shouldn't take so long. It sunds like your network is very slow. To verify that, copy the table to a local HD and run query from there.
>
>Again there is no network
>It is a single system and running on win98, Also the same case with Xp
My point is that it's not a query responsible for slowness but hardware.
--sb--