Project Status Report

Project Status Report

Trying to pull the following from the Project Module:

Title
Status
Owner
Latest Comment

Using the following statement, but having issues.  Any assistance?

SELECT projectdet.TITLE "Title",
projectowner.FIRST_NAME "Owner",
aau.FIRST_NAME "Commented by",
projectstatus.STATUSNAME "Status",
c.comment "Project Comments"FROM ProjectDetails projectdet
LEFT JOIN SDUser projectownerdet ON projectdet.OWNERID=projectownerdet.USERID LEFT JOIN AaaUser projectowner ON projectownerdet.USERID=projectowner.USER_ID
Left join projectcomments c on c.projectid = projectdet.projectid
LEFT JOIN ProjectStatus projectstatus ON projectdet.STATUSID=projectstatus.STATUSID
LEFT JOIN AaaUser aau ON aau.USER_ID=c.Commentowner  where 
  c.Commentid = (SELECT MAX(c1.Commentid) FROM projectcomments c1 WHERE c1.PROJECTID=projectdet.PROJECTID)
LEFT JOIN ProjectStatus projectstatus ON projectdet.STATUSID=projectstatus.STATUSID