SELECT * FROM f:\5star\updates\new\supplier; UNION ALL; SELECT * FROM f:\5star\updates\amend\supplier; INTO CURSOR suppliertmp INDEX ON DateTimeField TAG suppliertmpIf you want to use ORDER you must use Field list in SQL Stements above and use position of DateTime in ORDER BY clause:
SELECT Fld1, fld2, DateToOrder, fld4 ....FROM f:\5star\updates\new\supplier; UNION ALL; SELECT Fld1, fld2, DateToOrder, fld4 .... FROM f:\5star\updates\amend\supplier; ORDER BY 3 INTO CURSOR suppliertmp>Hi Borislav
>>>SELECT * from f:\5star\updates\new\supplier FULL OUTER JOIN f:\5star\updates\amend\supplier INTO CURSOR suppliertmp >>>>>>