error in Group by on LEFT OUTER JOIN

See more:

SQL-Server

SQL-Server-2008

, +

hi,
i get error below when add GROUP BY dbo.TBLTicketAnswers.AnswerID

Msg 8120, Level 16, State 1, Procedure GetTicketBySearch, Line 21
Column 'dbo.TBLTickets.UserID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

SELECT  TBLTickets.UserID ,
                            TBLTickets.TicketID ,
                            TBLTickets.AttachFile ,
                            TBLTickets.HasFile ,
                            TBLTickets.Title ,
                            TBLTickets.Question ,
                            TBLTicketBranchs.BranchName ,
                            TBLTicketAnswers.AnswerID ,
                            TBLTicketAnswers.Answer ,
                            TBLTickets.Flag ,
                            TBLUsers.UserName ,
                            TBLTickets.InsertDate ,
                            TBLUsers.UserOwner ,
                            TBLUsers.Corporation
                    FROM    dbo.TBLTicketBranchs
                            INNER JOIN dbo.TBLTickets ON dbo.TBLTicketBranchs.BranchID = dbo.TBLTickets.BranchID
                            INNER JOIN dbo.TBLUsers ON dbo.TBLTickets.UserID = dbo.TBLUsers.UserID
                            LEFT OUTER JOIN dbo.TBLTicketAnswers ON dbo.TBLTickets.TicketID = dbo.TBLTicketAnswers.TicketID
                    WHERE   ( TBLTicketBranchs.ResellerID = @ResellerID   
                              AND ( TBLTicketAnswers.Answer LIKE N'%'
                                    + @Keyword + '%'
                                    OR @Keyword IS NULL
                                    OR TBLTickets.Title LIKE N'%' + @Keyword
                                    + '%'
                                    OR @Keyword IS NULL
                                    OR TBLTickets.Question LIKE N'%'
                                    + @Keyword + '%'
                                    OR @Keyword IS NULL
                                    OR TBLUsers.UserName LIKE N'%' + @Keyword
                                    + '%'
                                    OR @Keyword IS NULL
                                  )
                            )
                        
          GROUP BY dbo.TBLTicketAnswers.AnswerID