Help with Outer Joins

Hi. I'm using Microsoft Query to create a query for Excel 2003. I'm
attempting to create 3 Left Outer Joins, but upon doing so I receive the
error message "Query Can Have Only One Outer Join" as described here...
http://support.microsoft.com/defaul...14027#appliesto
After reading this article, I am under the impression that multiple Outer
Joins CAN indeed be created, only you must write the SQL code directly in
order to create them. That's were I'm lost. I'm not sure how to write the
necessary SQL code in order to join the 3 tables. Could someone please
assist me with the necessary code?
My tables are: tblOrder, Customer, tblSQFTByStation, and tblOrderDetail
tblOrder should be joined to the other 3 tables as follows...
FROM {oj `H:\Application_be`.tblOrder tblOrder LEFT OUTER JOIN
`H:\Application_be`.tblSQFTByStation tblSQFTByStation ON tblOrder.OrderID =
tblSQFTByStation.OrderID}
FROM {oj `H:\Application_be`.tblOrder tblOrder LEFT OUTER JOIN
`H:\Application_be`.Customer Customer ON tblOrder.CustomerID =
Customer.CustomerID}
FROM {oj `H:\Application_be`.tblOrder tblOrder LEFT OUTER JOIN
`H:\Application_be`.tblOrderDetail tblOrderDetail ON tblOrder.OrderID =
tblOrderDetail.OrderID}What you might be missing is that each join is not from 1 source to another,
it is from what you have so far to anothersource...
So (THis is probably wrong syntactically cause I don't know Exce
lsyntax...)tr this structure.
FROM oj `H:\Application_be`.tblOrder tblOrder
LEFT OUTER JOIN `H:\Application_be`.tblSQFTByStation tblSQFTByStation
ON tblOrder.OrderID = tblSQFTByStation.OrderID
LEFT OUTER JOIN `H:\Application_be`.Customer Customer
ON tblOrder.CustomerID = Customer.CustomerID
LEFT OUTER JOIN `H:\Application_be`.tblOrderDetail tblOrderDetail
ON tblOrder.OrderID = tblOrderDetail.OrderID
"MrMike" wrote:

> Hi. I'm using Microsoft Query to create a query for Excel 2003. I'm
> attempting to create 3 Left Outer Joins, but upon doing so I receive the
> error message "Query Can Have Only One Outer Join" as described here...
> http://support.microsoft.com/defaul...14027#appliesto
> After reading this article, I am under the impression that multiple Outer
> Joins CAN indeed be created, only you must write the SQL code directly in
> order to create them. That's were I'm lost. I'm not sure how to write th
e
> necessary SQL code in order to join the 3 tables. Could someone please
> assist me with the necessary code?
> My tables are: tblOrder, Customer, tblSQFTByStation, and tblOrderDetail
> tblOrder should be joined to the other 3 tables as follows...
> FROM {oj `H:\Application_be`.tblOrder tblOrder LEFT OUTER JOIN
> `H:\Application_be`.tblSQFTByStation tblSQFTByStation ON tblOrder.OrderID
=
> tblSQFTByStation.OrderID}
> FROM {oj `H:\Application_be`.tblOrder tblOrder LEFT OUTER JOIN
> `H:\Application_be`.Customer Customer ON tblOrder.CustomerID =
> Customer.CustomerID}
> FROM {oj `H:\Application_be`.tblOrder tblOrder LEFT OUTER JOIN
> `H:\Application_be`.tblOrderDetail tblOrderDetail ON tblOrder.OrderID =
> tblOrderDetail.OrderID}
>|||Thanks!
"CBretana" wrote:
> What you might be missing is that each join is not from 1 source to anothe
r,
> it is from what you have so far to anothersource...
> So (THis is probably wrong syntactically cause I don't know Exce
> lsyntax...)tr this structure.
> FROM oj `H:\Application_be`.tblOrder tblOrder
> LEFT OUTER JOIN `H:\Application_be`.tblSQFTByStation tblSQFTByStation
> ON tblOrder.OrderID = tblSQFTByStation.OrderID
> LEFT OUTER JOIN `H:\Application_be`.Customer Customer
> ON tblOrder.CustomerID = Customer.CustomerID
> LEFT OUTER JOIN `H:\Application_be`.tblOrderDetail tblOrderDetail
> ON tblOrder.OrderID = tblOrderDetail.OrderID
>
> "MrMike" wrote:
>