Did you also change the == to =?

>hi jamie,
>
>i tried your suggestion and purno&rcno has an index but no changes the select statement is too slow to execute,, all i need is a replacement for this select statement.
>
>pls help
>
>thanks,