Re: sql from access-pls analyze this error
Posted by:
Bob Field
Date: July 06, 2006 09:10AM
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.]
Subject
Views
Written By
Posted
2377
July 06, 2006 08:12AM
Re: sql from access-pls analyze this error
1471
July 06, 2006 09:10AM
1513
July 07, 2006 08:42AM
1528
July 07, 2006 09:25AM
1548
July 08, 2006 12:48AM
1432
July 08, 2006 07:28AM
1380
July 08, 2006 11:39PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.