>SELECT dSiMain.*, dSisUb.icode, dSisUb.Quantity, dSisUb.Rate,; > dPCode.pname, dIcode.full_desc, dIcode.maincat, dIcode.category,dIcode.subcat ; > FROM dSiMain; > RIGHT JOIN dSisUb ON dSiMain.SiNo == dSisUb.SiNo; > LEFT JOIN dPCode ON dSiMain.pcode == dPCode.pcode; > LEFT JOIN dIcode ON dSisUb.icode == dIcode.icode; > WHERE BETWEEN(dSiMain.DATE, dt1, dt2) ; > INTO CURSOR tempsale ORDER BY maincat > >