Re: Oracle Subquery Question

From: jean-marc pyrée <jmpyree_at_club-internet.fr>
Date: Tue, 23 Jan 2001 03:15:57 +0100
Message-ID: <94ipcd$npi$1@front4m.grolier.fr>

Try:

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
group by a.part_no

<z2124_at_my-deja.com> a écrit dans le message news: 94imcv$mhq$1_at_nnrp1.deja.com...
> 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 - 20:15:57 CST