Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Merge two tables
Message
From
23/08/2011 03:35:41
 
 
To
23/08/2011 03:14:55
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01521557
Message ID:
01521560
Views:
50
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform