>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

I think it is risky to hard-code the location (drive and directory). Perhaps later you move the data to another location - and have to change the location in hundreds of places.

Better do something like

set path to ..., k:\fas

to ensure that the data is found there. The SET PATH would be required only once, in the startup program.