Hello friends. I'm trying to make a query in SQL SERVER that works perfectly in SQLite. Does anyone know how I can make it work?
SELECT B.CLIENT, A.CODCLI, SUM (A.VALORPAGO.VALUE) AS 'RECEIVE & # 39;
FROM THE ARGCONTASRECEBER A
INNER JOIN ARGCLIENT B
ON A.CODCLI = B.CODCLI
O A VALORPAGO <A.VALOR
GROUP BY A.CODCLI
Message 8120, Level 16, State 1, Line 1
The column 'CLIENT ARGCLIENT & # 39; is not valid in the selection list because it is not in an aggregate function or in the GROUP BY clause.
Thanks in advance!