Oracle Subquery Question

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 Received on Mon Jan 22 2001 - 20:02:13 CST