I have simplified the model of what I'm trying to do so hopefully this makes sense.
I have three tables basically two pieces of information and a join.
tbl_users tbl_join_users_comments tbl_comments
pk_user pk_join pk_comment
user pk_user comment
So what I want is a view that returns a column with the user, a column with the count of the number of joins for that user and a comment, and a column with the LAST entered comment joined to the user.