HI,
I am trying to concatenate two column alises and am getting an error.
If I use only one alias and keep the other column as it is, the
concatenation works fine..But if I use aliases for two columns and try
to concatenate the two, it doesn't work.
The statement is like this...
-----
, brk.division division
, SUM((NVL(rctl.quantity_invoiced,0)* NVL(msi.attribute13,1)) +
(NVL(rctl.quantity_credited,0)* NVL(msi.attribute13,1)))
cases_this_month
SUM(NVL(rctl.revenue_amount,0)) dollars_this_month
, msi.attribute12


here I want to be able to concatenate cases_this_month and
dollars_this_month..

Any help would be appreciated.

Thanks
Asgar