Hi i am trying to convert php code written to work with MySql 4 to work with 3.22. Could some one help me figure out what I need to change. From looking at the mysql manuel it looks like the INNER tag is the problem but I am not sure how it should be changed.
define('SQL_PROJECTS_LIST_ALL',
'SELECT
p.ID, p.Status, p.TargetBudget, p.ClientID, c.Name as ClientName, p.Name as ProjectName,
p.StartDate, p.EndDate, p.Colour, AVG(IFNULL(t.PercentComplete, 0)) AS PercentComplete,
u.FirstName, u.LastName, p.Owner
FROM tblProjects AS p
LEFT JOIN tblUsers AS u ON u.ID = p.Owner
LEFT JOIN tblTasks AS t ON t.ProjectID = p.ID
INNER JOIN tblClients AS c ON c.ID = p.ClientID
WHERE p.Active = \'%1$s\'
GROUP BY p.ID
ORDER BY %2$s %3$s');
