using this SQL command

select pat.cfg_tipo, pat.cfg_codice, sum(pat.importo_dovuto) importo_dovuto,

coalesce((select sum(importo_pagato) from pas where pas.progressivo =
pat.progressivo), 0) importo_pagato
from pat
where pat.cfg_tipo = 'C'

I receive this error

Invalid expression in the select list (not contained in either an aggregate
function or the GROUP BY clause).


what I have to do? ...

fab10
.-----------------------------.