Information générale
Catégorie:
Codage, syntaxe et commandes
As far as I can tell, Agnes gave you the best answer, but of course her initial SQL statement merely duplicates your original table but with possibly different field names and a new table name. I agree with Agnes that you need tables with a common field in order to do the relation, but I have a problem understanding the need to create a new table identical to the original table. Why do you really need two new tables?
Alan
>Thank you Caroline
>But I think I mistyped my question
>
>I need sql command to create 2 new tables from my table
>
>I have a table with struct (4 fields)
>
> Name(field1)
> Field2
> Field3
> Field4
>
> I have many repated names (field1)
>
> Carl
> John
> Carl
> Moses
> Carl
> Etc.
>
>
> I need I new table for name (without repeat names)
>and I new table for field1, field2 and field3
>
>Moses
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