Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Merge two tables
Message
De
23/08/2011 03:35:41
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01521557
Message ID:
01521560
Vues:
49
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform