I have a table with a list of projects and a related table with the project history. I am now working on a simple query to bring up all projects and their last history comment.
My issue is that I have projects which still do not have any history in them (sometimes it takes a while to start them or assign them) and this query does not bring up those projects.
How can I make this query show all projects, including the ones that do not have history?
Mafhobb
Code:
SELECT tblProject.PropertyName, tblProject.ProjectName, tblProject.Status, tblProject.Involved, Last(tblProjectHistory.HistoryComment) AS LastOfHistoryComment
FROM tblProject INNER JOIN tblProjectHistory ON tblProject.ProjectID = tblProjectHistory.ProjectID
GROUP BY tblProject.PropertyName, tblProject.ProjectName, tblProject.Status, tblProject.Involved;
How can I make this query show all projects, including the ones that do not have history?
Mafhobb