Information générale
Catégorie:
Codage, syntaxe et commandes
Hi Ken,
Thanks for your reply.
Let me describe the relation between these three tables (Order, Order-1 and Order-2) in more details.
Order (Order-No, Order-Date, Cust-Code,...)
Key = Order-No
Order-1 (Order-No, Stock-No, Color-ID, Order-Qty, Order-Price,...)
Key = Order-No
Order-2 (Order-No, Stock-No, Color-ID, Deli-Qty, Deli-Date,...)
Key = Order-No + Stock-No + Color-ID
Each Order can have more than one Order-1 records.
Each Order-1 can have more than one Order-2 records.
I want to join these three tables to form a new table which contain the following attributes:-
(Order-No, Order-Date, Cust-Code, Stock-No, Color-ID, Order-Qty, Order-Price, Deli-Qty, Deli-Date,...)
I want to use the Select - Join statement of join those three tables.
Order table is used the key (Order-No) to join with the Order-1 table.
Order-1 table is used the key (Order-No+Stock-No+Color-ID) to join with the Order-2 table.
And i want to know how to join these three tables.
Thanks for your assistance.
Dennis
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