>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 >