I tried this but got the same result...:(
SELECT * FROM bp_eng_t;
union all;
SELECT * FROM bp_eng_o;
into CURSOR temp
>>How can I merge two tables?
>>I tried to merge two tables(thier sturctures are identical) with the command "union" but it failed.
>>I got an error message which says the memo file(fpt) is missing.
>>
>>Thanks,
>>Tamas
>
>Memo file is FPT :-)
>use UNION ALL instead.
>When you use just union SQL Engine tries to filter duplicated records this operation is invalid for Memo, BLOB etc. fields.