>I need to use SQL - SELECT statement to join three tables (Order, Order-1, Order-2). The join condtion of these three tables are:-
>
>Join condtion of Order & Order-1 & Order-2
> OrderNo
>Join condition of Order-1 & Order-2
> OrderNo+Stockno+ColorID
>All records of tables (Order, Order-1 and Order-2) must be existed in the new table.
>
>Would anybody can tell how to write this join statement.
>
>Thanks
>
>Dennis
I'm not sure from the above what your keys are, but if both Order1 and Order2 are keyed off of Order do this:
SELECT Order.*, Order1.*, Order2.* FROM Order
LEFT OUTER JOIN ON Order1 WHERE Order1.keyval = Order.keyval
LEFT OUTER JOIN ON Order2 WHERE Order2.keyval = Order.keyval
If Order2 is keyed off of Order1 vs Order then replace the last Order.keyval with Order1.keyval