I have a sql query question.
I have 2 tables... Projects and ProjComments
Projects has 2 fields ProjID and ProjName
ProjComments has 4 fields. ProjCommentID, ProjID, CommentDate and Comment
There can be several comments on one project
what sql code would I use to select all projects and only the most recent
comment for each project? Some projects won't have any comments.
so my results would include
ProjID, ProjName, comment Date and Comment.