I'm trying to move a MySQL DB to Access.
This MySQL query generates a syntax error:
SELECT c.CL_ID, c.Busname, c.Contact, c.Addr1, c.Addr2, c.City, c.State, c.Zip, c.Email, c.CL_ChgDate, sp.Lastname, sp.Firstname, a.Description, a.Rate FROM Clients c
LEFT OUTER JOIN Salespersons sp ON c.SP_ID = sp.SP_ID
INNER JOIN Ads a ON a.AD_ID = c.AD_ID
WHERE (a.Description <> 'Unknown')
ORDER BY c.Busname
Is it because of the aliases?
Many thanks...
Todd