SELECT * FROM f:\5star\updates\new\supplier;
UNION ALL;
SELECT * FROM f:\5star\updates\amend\supplier;
INTO CURSOR suppliertmp
INDEX ON DateTimeField TAG suppliertmp

If you want to use ORDER you must use Field list in SQL Stements above and use position of DateTime in ORDER BY clause:
i.e

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
>
>I don't want to join tables for specific fields, just want to create a new table with everything from both tables and sort it into date & time order.
>
>>>Hi!
>>>
>>>All I want to do is join two tables together of identical file structure,
>>>
>>>

>>>SELECT * from f:\5star\updates\new\supplier FULL OUTER JOIN f:\5star\updates\amend\supplier INTO CURSOR suppliertmp
>>>

>>>
>>>Can't work out whats wrong with the above line? Ah well, it is Monday morning
>>>
>>>TAI
>>
>>You didn't specify the fields for joining tables.
>>also, did you want JOIN or you want UNION ALL?