>>>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
>
>
>I like the following better. It reserves the WHERE keyword to filters rather than join conditions:
>
>SELECT Order.*, Order1.*, Order2.* FROM Order
> LEFT OUTER JOIN Order1 ON Order1.keyval = Order.keyval
> LEFT OUTER JOIN Order2 ON Order2.keyval = Order.keyval

You're absolutely correct...I did this with a hangover this am...and screwed it up ;)