Re: sql from access-pls analyze this error

[Bob Field]

The bracket syntax is not accepted by MySQL. If an identifier needs to be enclosed because it has spaces, reserved characters, or is a reserved word, enclose it in backticks. In this instance lose the brackets and you'll be fine.

SELECT d.OrderID, d.DateSold, d.SalePrice, q.Referedby1, d.SalePrice*0.04 AS ReferredBy1Comm
FROM OrderDetails AS d
JOIN Query1 AS q ON OrderDetails.ContactAutoID = Query1.ContactAutoID
WHERE q.Referedby1 IS NOT NULL
AND q.Referedby1>0;

[I've never liked the output of the Access query builder.]