You are welcome

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