FROM clause syntax

[Mike555]

I'm trying to use the below FROM clause in a query, but it is consistantly returning the error "Syntax error in JOIN operation." Could someone please help me understand why this error is occuring? Thanks.

FROM qryproductionreportdetailset
LEFT JOIN tblOrder ON qryproductionreportdetailset.OrderID = tblOrder.OrderID, qryproductionreportdetailset
INNER JOIN tblOrderDetail ON tblOrder.OrderID = tblOrderDetail.OrderID

--
Mike

"Don’t get suckered in by the comments – they can be terribly misleading. Debug
only code. – Dave Storer.

 

[lupins46]

, qryproductionreportdetailset

Remove this...

 

[Mike555]

Thanks for the reply. I've updated the code but now I receive the error "Syntax Error (missing operator) in query expression..." Any ideas what could be causing this? Thanks.

FROM qryproductionreportdetailset LEFT JOIN tblOrder ON qryproductionreportdetailset.OrderID = tblOrder.OrderID INNER JOIN tblOrderDetail ON tblOrder.OrderID = tblOrderDetail.OrderID

--
Mike

"Don’t get suckered in by the comments – they can be terribly misleading. Debug
only code. – Dave Storer.

 

[Mike555]

I've found the problem. THe updated code is...

FROM (tblOrder INNER JOIN qryProductionReportDetailSet ON tblOrder.OrderID = qryProductionReportDetailSet.OrderID) INNER JOIN tblOrderDetail ON tblOrder.OrderID = tblOrderDetail.OrderID

--
Mike

"Don’t get suckered in by the comments – they can be terribly misleading. Debug
only code. – Dave Storer.

 

[lespaul]

Ok, your first query had left joins and now your solution only has inner joins, are you sure you are getting the correct information?

Leslie

 

[Mike555]

I should have explained...

I tried typing the syntax by myself the first time incorrectly. I then created a new query, added the appropriate tables, and opened SQL View in order to see how Access generated the FROM. Thanks.

--
Mike

"Don’t get suckered in by the comments – they can be terribly misleading. Debug
only code. – Dave Storer.