Mettre les données de deux tables dans une troisième table

[kotor70]

Bonjour ,
J'ai deux tables:
Envoi(Num_Mvt_E,Date_Mvt_E,Action,Objet,Num_Tel_En voi,Num_Tel_Reception,Montant_Mvt_Envoi)



RETOUR(Num_Mvt_R,DateMvt_R,Action,Objet,Num_Tel_Re ception,Num_Tel_Envoi,Montant_Mvt_Retour)

Question: je voudrais avoir les données des deux tables dans une troisième table X ou requete, dont les champs seront:

TableX(Num_Mvt_E,Date_Mvt_E,Action,Objet,Num_Tel_E nvoi,Num_Tel_Reception,Montant_Mvt_Envoi,Num_Mvt_R ,DateMvt_R,Action,Objet,Num_Tel_Reception,Num_Tel_ Envoi,Montant_Mvt_Retour).
Cordialement,

[June7]

I tried Google Translate in attempt to understand your post. Since this is an English language forum, it would be helpful if you posted in English.

How are these tables related? Are they both related to another table? Have you tried building a query? Do you want to JOIN or UNION this data?

Seems you need a better understanding of RDMS principles. Here is a good tutorial site http://www.rogersaccesslibrary.com/

[John_G]

How do you know which record(s) in RETOUR correspond to each record in Envoi?

Unless you have a field or fields in common between the two tables, you can't join them because you dont have enough data to do so.