Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>What is the easiest way to append all the fields from one (current) record in a table to a second table? The table I want to copy the fields to contains more fields than the first and the order of the matching fields does not corrispond to the order of fields in the first table.
>
>I've been using insert but it makes for very large statement because I have to spellout all the fields in both tables.
>
>Is there something like Append which matches fields in the target table regardless of their order?
>
>TIA
>
>Ken Ward
SELECT < 1st Table >
SCATTER MEMVAR MEMO
SELECT < 2nd Table >
INSERT INTO < 2nd TAble > FROM MEMVAR
or use Mark's suggestion.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement