SELECT SoMain.*, SosUb.ICode, SosUb.qntymaj, SosUb.qntymin,; SosUb.RateMaj, SosUb.RateMin,; PCode.full_Name, PCode.address, PCode.tel1, PCode.tel2, PCode.tel3, ; ICode.full_desc, ICode.unit ; FROM (lcPathSoMain) SoMain; JOIN (lcPathSosUb) SosUb ON SoMain.SoNo == SosUb.SoNo; LEFT JOIN (lcPathPCode) PCode ON SoMain.PCode == PCode.PCode; LEFT JOIN (lcPathIcode) ICode ON SosUb.ICode == ICode.ICode; WHERE BETWEEN(SoMain.date, dt1, dt2) ; INTO CURSOR cSomain