Syntax Error in FROM clause

[Guest]

Hi. I have the query as shown below. When executed it produces the error
"Syntax error (missing operator) in query expression tblSQFTByStation.OrderID
= tblOrder.OrderID
INNER JOIN tblOrderDetail on tblSQFTByStation.OrderID =
tblOrderDetail.OrderID" I can't figure out what is wrong. Could someone
please assist? Thanks!

SELECT tblSQFTByStation.OrderID, IIF(ECD_CutOff Is Null, "","CutOff") as
Station, CutOff as Requirements,(SELECT SUM(tblOrderDetail.Width) FROM
tblOrderDetail WHERE tblOrderDetail.FlitchNum = tblSQFTByStation.OrderID)
FROM tblSQFTByStation
INNER JOIN tblOrder on tblSQFTByStation.OrderID = tblOrder.OrderID
INNER JOIN tblOrderDetail on tblSQFTByStation.OrderID = tblOrderDetail.OrderID
WHERE ((ECD_CutOff Is Not Null) AND (tblOrder.StatusID = 3 OR
tblOrder.StatusID = 4 OR tblOrder.StatusID = 5 OR tblOrder.StatusID = 6 OR
tblOrder.StatusID = 7 OR tblOrder.StatusID = 12 OR tblOrder.StatusID = 13));

 

[Van T. Dinh]

In JET SQL, you need parentheses for each join except the outer most join.

Try:

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


--
HTH
Van T. Dinh
MVP (Access)

Hi. I have the query as shown below. When executed it produces the error
"Syntax error (missing operator) in query expression tblSQFTByStation.OrderID
= tblOrder.OrderID
INNER JOIN tblOrderDetail on tblSQFTByStation.OrderID =
tblOrderDetail.OrderID" I can't figure out what is wrong. Could someone
please assist? Thanks!

SELECT tblSQFTByStation.OrderID, IIF(ECD_CutOff Is Null, "","CutOff") as
Station, CutOff as Requirements,(SELECT SUM(tblOrderDetail.Width) FROM
tblOrderDetail WHERE tblOrderDetail.FlitchNum = tblSQFTByStation.OrderID)
FROM tblSQFTByStation
INNER JOIN tblOrder on tblSQFTByStation.OrderID = tblOrder.OrderID
INNER JOIN tblOrderDetail on tblSQFTByStation.OrderID = tblOrderDetail.OrderID
WHERE ((ECD_CutOff Is Not Null) AND (tblOrder.StatusID = 3 OR
tblOrder.StatusID = 4 OR tblOrder.StatusID = 5 OR tblOrder.StatusID = 6 OR
tblOrder.StatusID = 7 OR tblOrder.StatusID = 12 OR tblOrder.StatusID =

13));

 

[Guest]

Thanks! That's what was needed.

In JET SQL, you need parentheses for each join except the outer most join.

Try:

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


--
HTH
Van T. Dinh
MVP (Access)



13));