Re: Oracle Subquery Question

From: Myron Wintonyk <mwintony_at_med.ualberta.ca>
Date: Tue, 23 Jan 2001 13:34:39 +1000
Message-ID: <3A6CFBCF.6354A77C@med.ualberta.ca>

What version of Oracle are you using? As I recall, this doesn't work in Oracle 7.3
(I could be completely wrong on this). I actually created the tables and tried this query.
It worked fine. I'm using Oracle 8i (8.1.6) on Sun Solaris.

z2124_at_my-deja.com wrote:

> I am having a problem with what should be a simple query. The
> following query is returning a ORA-00936, 'Missing Expression' error
> message.
>
> select a.part_no,
> (SELECT sum(qty_onhand) FROM inventory_part_location_tab b
> WHERE a.part_no = b.part_no)
> from inventory_part_tab a
>
> I am trying to return two fields, part_no and a sum of quantities.
> What am I missing?
>
> TIA
>
> Sent via Deja.com
> http://www.deja.com/
Received on Mon Jan 22 2001 - 21:34:39 CST