I have following statement

select bli."Bil_Number",cln."FName"
from "Bill_Items" bli join "Bill_Main" bil
on bli."Bil_Number" = bil."Ref_Number"
join "Client_Main" cln
on cln."Ref_Number" = bil."Cln_Number"

and when I add plan

*plan join (bil natural, cln index ("Cln_By_Number"), bli index
("Bli_By_Inv_Number"))*/

to it i get error saying Index "Cln_By_Number" doesn't exists for
table "Client_Main". I've tried using it without quotes (I'm using
dialect 3).

and when i execute it without plan the plan shown in Ibconsole is
as
PLAN JOIN (BIL NATURAL,CLN INDEX (Cln_By_Number),BLI
INDEX (Bli_By_Inv_Number))

Am I missing something?

Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz