Re: Adding two different columns in a view

The parens may be causing a problem, try

select TOT_AMT_BOUGHT + TOT_AMT_PAID As GrandTotal from WV82_UNION;

hth,

"gamaz" <gamaz_at_earthlink.net> wrote:

>
>Hi,
>I have a view name WV82_UNION where there are two columns; TOT_AMT_BOUGHT
>and TOT_AMT_PAID
>
>Now I have to select a column which will add up the above two columns. I am
>issuing the following commands:
>
>select (TOT_AMT_BOUGHT + TOT_AMT_PAID) from WV82_UNION;
> *
>However, I am getting the following error.
>
>ERROR at line 1:
>ORA-00942: table or view does not exist
>
>My question is: Is the query expression correct or do I need some
>modification . Thanks in advance for any help.
>Regards.
>

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Fri Sep 20 2002 - 11:29:26 CDT