Codeignier---sql database

-2 votes

2 answers

33 views

sql-server sql-server-2008 codeigniter

                          >[Microsoft][SQL Server Native Client 11.0][SQL Server]Column 'TantraBackup00.GuildName' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

    SELECT 
        PK.KillerAccountName as CharacterName 
        ,count(PK.KillerAccountName) as totalkillings
        , TB.GuildName 
    FROM PlayerKills as PK 
           LEFT JOIN 
        TantraBackup00 as TB ON PK.KillerAccountName = TB.CharacterName 
    WHERE 
        PK.KillerCharacterName !='' 
    GROUP BY PK.KillerAccountName
                        

Asked by chirag jogani (1 rep)

Apr 30, 2021, 10:11 AM
Last activity: Apr 30, 2021, 12:19 PM

Codeignier---sql database

Related Questions