Re: Oracle Subquery Question

I believe a simpler way to write this query would be: select part_no, sum(qty_onhand)
from inventory_part_location_tab
group by part_no

Try that, let me know how that works...

HTH
RHC
SL 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

--
Posted via CNET Help.com
http://www.help.com/