I'd check what is in your lcString* first.

>Hi,
>
>I am facing a syntax error in the following SQL-Select, but I could not find it please guide..
>

>SELECT Simain.sino, Simain.invdate, Simain.pcode, Simain.location,;
>  Simain.cashname, Simain.salesman, Simain.merchand, Sisub.icode,;
>  Sisub.qntymaj, Sisub.qntymin, Sisub.ratemaj, Sisub.ratemin, Saleprog.zone,;
>  Kategory.maincat, Kategory.category, Kategory.subcat1, Kategory.subcat2,;
>  Icode.barcode, Icode.full_desc, Customer.full_name;
> FROM ;
>     vfas!simain ;
>    INNER JOIN vfas!sisub ;
>   ON  Simain.sino = Sisub.sino ;
>    INNER JOIN vfas!saleprog ;
>   ON  Simain.salesman = Saleprog.salesman ;
>    INNER JOIN vfas!kategory ;
>   ON  Sisub.icode = Kategory.icode ;
>    INNER JOIN vfas!icode ;
>   ON  Sisub.icode = Icode.icode ;
>    INNER JOIN vfas!customer ;
>   ON  Simain.pcode = Customer.pcode ;
>   WHERE tKategory.mainCat IN(&lcString) AND ;
>                           tKategory.category IN(&lcString1) AND ;
>                            tKategory.subCat1 IN(&lcString2) AND ;
>                            tKategory.subCat2 IN(&lcString3) INTO CURSOR Salqry1 READWRITE
>