SELECT SiMain.*, SisUb.ICode, SisUb.qntymaj, , SisUb.qntymin, , SisUb.RateMaj, SisUb.RateMin,;
       PCode.PName, Icode.full_desc;
       FROM SiMain;
       LEFT JOIN SisUp ON SiMain.SiNo  == SisUp.SiNo; && May be You need RIGHT JOIN here?
       LEFT JOIN PCode ON SiMain.PCode == PCode.PCode;
       LEFT JOIN Icode ON SisUp.Icode  == Icode.Icode;
       WHERE BETWEEN(Simain.Invdate, mdt1, mdt2)        .AND.;
             UPPER(Simain.Salesman) == UPPER(msalesman) .AND.;
             Simain.PCode == mpcode;
INTO CURSOR cTest