As per your suggestion, I generate a SQL-command as follows:

	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 SoMain;
	  RIGHT JOIN SosUb ON SoMain.SoNo == SosUb.SoNo;
	  LEFT JOIN PCode ON SoMain.PCode == PCode.PCode;
	  LEFT JOIN Icode ON SosUb.Icode  == Icode.Icode;
	  WHERE BETWEEN(SoMain.date, dt1, dt2) INTO CURSOR cSomain

In Network environment, the actual data is lying in (K:\FAS) directory and I want to fetch data from there. But I am facing a problem to put the drive letter. Kindly let me know where to put the drive letter in the above SQL command.

Thanks - Saif