hi, i am trying to move one of the databases we have in access to mysql and i have come accross a query that mysql doesnt like:
SELECT Managers.Manager, Agents.Agent, Modules.Module, Messages.MLevel, Messages.Title, MessageInstance.Name, MessageInstance.Info, PolicyRuns.JobNo, Policies.Policy FROM Messages INNER JOIN (Managers INNER JOIN (((PolicyRuns INNER JOIN ((Modules INNER JOIN PolicyModule ON Modules.ID = PolicyModule.ModuleID) INNER JOIN Policies ON PolicyModule.PolicyID = Policies.ID) ON (PolicyRuns.PolicyID = Policies.ID) AND (PolicyRuns.ModuleID = Modules.ID)) INNER JOIN MessageInstance ON PolicyRuns.ID = MessageInstance.PolicyRunID) INNER JOIN Agents ON PolicyRuns.AgentID = Agents.ID) ON (Managers.ID = Agents.ManagerID) AND (Managers.ID = Policies.ManagerID)) ON Messages.ID = MessageInstance.MessageID WHERE (((Policies.Policy)="CM-First Audit")); what might be possibly wrong with the query? how can i make it work in mysql ? thanx in advance, terry --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php