Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Oracle Subquery Question

Oracle Subquery Question

From: <z2124_at_my-deja.com>
Date: Tue, 23 Jan 2001 01:22:45 GMT
Message-ID: <94imcv$mhq$1@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 - 19:22:45 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US