Thanks Borislav

>

>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?