Database

SELECT      
K.KIDID,      
K.STUDENTNUMBER,      
KIDNAME,      
KIDLASTNAME ,      
SC.SCHOOLNAME ,      
KIDGRADE ,      
KIDCLASS ,      
SC.SCHOOLID,  
k.TEMP_BARCODE,
PHOTO,
A.ACCOUNTID
,SUM(TRANSACTION_AMOUNT) AS [BALANCE]  
FROM       
KIDS_DETAILS K      
INNER JOIN SCHOOL SC       
ON K.SCHOOLID = SC.SCHOOLID      
INNER JOIN PARENTKID PK       
ON PK.KIDID = K.KIDID
INNER JOIN USERS U 
ON U.USERID  = K.USERID 
INNER JOIN ACCOUNTS A 
ON A.USERID = U.USERID
INNER JOIN ACCOUNTRANSATIONS AT
ON AT.ACCOUNTID  = A.ACCOUNTID
LEFT OUTER JOIN KIDSPHOTO KP
ON KP.KIDID = K.KIDID
 
  GROUP BY
K.KIDID,      
K.STUDENTNUMBER,      
KIDNAME,      
KIDLASTNAME ,      
SC.SCHOOLNAME ,      
KIDGRADE ,      
KIDCLASS ,      
SC.SCHOOLID,  
k.TEMP_BARCODE,
A.ACCOUNTID,
PHOTO

Column 'KIDSPHOTO.PHOTO' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Msg 306, Level 16, State 2, Line 40
The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.