>Thanks for pointing, kindly let me know how can replace that right syntax which the suggestion you mentioned.

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