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