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