sql from access-pls analyze this error

[sunil kattathara]

Hi,
This is the error i recieved [phpmyadmin] when when tried to qry table in MySql
with sql from a working access db

Error

SQL query: Documentation

SELECT OrderDetails.OrderID, OrderDetails.DateSold, OrderDetails.SalePrice, Query1.Referedby1, [SalePrice] * 0.04 AS ReferredBy1Comm
FROM OrderDetails
INNER JOIN Query1 ON OrderDetails.ContactAutoID = Query1.ContactAutoID
WHERE (
(
(
Query1.Referedby1
) IS NOT NULL
AND (
Query1.Referedby1
) >0
)
);

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[SalePrice]*0.04 AS ReferredBy1Comm
FROM OrderDetails INNER JOIN Query1 ON Orde' at line 1

not that wellversed in sql...pls help
sunil