How to group by this SQL statement

[wbarona]

Hello everyone,

Could you please provide me with some assistance on how to group by a SQL statement when a selected column comes from a subquery. Here is an example of the SQL statement I am trying to write. I don't know what to add to the group by command in order to make it work.


Thanks for your help and guidance

select sa.sa_type_cd,
nvl((select bsegitem.item_cnt
from ps_ci_bseg bseg,
ps_ci_bseg_item bsegitem
where bseg.bseg_id = bsegitem.bseg_id
and bseg.bill_id = ft.bill_id
and bsegitem.item_type_cd = 'WT-UNITS'),0),
sum(ftgl.statistic_amount),
sum(ftgl.monetary_amount) * -1

from ps_ci_sa sa,
ps_ci_sa_type satype,
ps_ci_ft ft,
ps_ci_ft_gl ftgl
where sa.sa_type_cd = satype.sa_type_cd
and sa.sa_id = ft.sa_id
and ft.ft_id = ftgl.ft_id
and trunc(ftgl.journal_date) between '01-Aug-2007' and '31-Aug-2007'
group by sa.sa_type_cd