select TRUNC(DATETIME,'MM') DATETIME
,BSC as BSC
,SUM(NVL(TASSALL,0)) as CALL_VOLUME
,ROUND((DIV(NVL(TCASSALL,0),NVL(TASSALL,0))),2)*100 as T_AS_SUCC
WHERE DATETIME BETWEEN to_date('01/09/2009 00:00:00','DD-MM-YYYY HH24:MI:SS') and to_date('30/09/2009 23:59:59','DD-MM-YYYY HH24:MI:SS')
group by datetime,bsc
When I run this, I get TCASSALL not a group by expression.
Now my problem is I don't want to group by TFCASSAL. I only want to group by DATETIME, BSC.
CELLS is a table. Do I need to create a VIEW of it?