LEFT OUTER JOIN在Group by中的错误 [英] error in Group by on LEFT OUTER JOIN

问题描述

i获取错误时添加GROUP BY dbo.TBLTicketAnswers.AnswerID



Msg 8120，Level 16，State 1，程序GetTicketBySearch，第21行

列'dbo.TBLTickets.UserID'在选择列表中无效，因为它不包含在聚合函数或GROUP BY子句中。

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

推荐答案

您无法使用 GROUP BY [ ^ ]没有汇总函数 [ ^ ]。

You can't use GROUP BY[^] without one of aggregate functions[^].

这篇关于LEFT OUTER JOIN在Group by中的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！