Re: Oracle Subquery Question

Same error. If I execute the subquery directly, 'SELECT sum(qty_onhand) FROM inventory_part_tab a, inventory_part_location_tab b WHERE a.part_no = b.part_no', it works fine.

On Tue, 23 Jan 2001 03:15:57 +0100, "jean-marc pyrée" <jmpyree_at_club-internet.fr> wrote:

>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:28:59 CST