[MYSQL] Select quasi impossibile

[devilchan]

SELECT DISTINCT coffis, (SELECT codfis, [num1]+[num2]+[num3] AS TOT
FROM Tabella1 ) AS tot
FROM Tabella1
WHERE id="AAA";