text to lcQuery pretext 1+2+4+8 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 &lcQuery>Hi,
>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 >