Re: ORA-00918: column ambiguously defined

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 23 Feb 2007 12:05:00 -0800
Message-ID: <1172261100.569659.136640@m58g2000cwm.googlegroups.com>

On Feb 20, 8:33 am, timothy.h..._at_gmail.com wrote:
> Hi,
>
> I am getting the above error when I try and run the query below on
>
> select com.name
> , curr.quantity
> , prev.quantity
> from ( select count(*) as quantity
> , a.tab_urn

Would the second and third columns not be named the same (ie QUANTITY).
How about providing a column alias, as in ... select com.name,curr.quantity "Curr_Quantity", prev.quantity "Prev_Quantity" from ...

Hth Received on Fri Feb 23 2007 - 14:05:00 CST