Beg your pardon I have a numb day.
>
SELECT;
TAlias1.time1, TAlias1.date1,;
TAlias1.roomno, TAlias1.place1,;
TAlias2.mobile, TAlias2.tel,;
TAlias2.empname, TAlias1.discerror,;
TAlias1.sno, TAlias1.mark1,;
talias3.empname;
FROM trans1 AS TAlias1;
INNER JOIN emp1 AS TAlias2;
ON TAlias1.empno = TAlias2.empno;
INNER JOIN empdep AS talias3;
ON TAlias1.fexerno=talias3.empno;
WHERE TAlias1.fexerno=0;
ORDER BY date1,sno ;
NOFILTER;
INTO CURSOR TAliascursor1
Agnes
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]
