Hi,
While running the following query failed to get the required records. The intention is mentioned in subject.
Please guide me.
Thanks
Abbasaif
While running the following query failed to get the required records. The intention is mentioned in subject.
Please guide me.
Thanks
Abbasaif
Code:
SELECT Somain.sono, Somain.sodate, Somain.duedate, Somain.pcode,;
Customer.full_name, Somain.location, Somain.cashname, Somain.enteredby,;
Somain.salesman, Somain.merchand, Somain.lpo, Somain.zone,;
Somain.discamount, Somain.discrem, Somain.remarks, Somain.marks,;
Somain.sprem, Sosub.icode, Sosub.vatperc, Sosub.qntymaj, Sosub.qntymin,;
Sosub.ratemaj, Sosub.ratemin ;
FROM ;
village!SoMain ;
INNER JOIN village!SoSub ;
ON Somain.sono = Sosub.sono ;
INNER JOIN village!Customer ;
ON Somain.pcode = Customer.pcode;
Where Deleted() ;
INTO CURSOR ViewSo READWRITE NOFILTER