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

Home -> Community -> Usenet -> c.d.o.server -> Re: Subquery Question

Re: Subquery Question

From: Paul Izzo <paul.izzo_at_mosca-ag.com>
Date: 18 Feb 2005 01:35:06 -0800
Message-ID: <1108719306.357799.87500@o13g2000cwo.googlegroups.com> 





No this is not homework this is a real problem that I have.   This is
what I've gotten so far.  I'm just getting now a problem with syntax.



select papp.ARBEITSPLAN_NR,papp.BELEGUNGSEINHEIT_NR
from w100.papp,w100.papk


where papp.ARBEITSPLAN_NR = papk.ARBEITSPLAN_NR
and papp.BELEGUNGSEINHEIT_NR in (3400,3500,3430)
and having count(papp.POSITIONS_NR) = 3
Received on Fri Feb 18 2005 - 03:35:06 CST












Original text of this message













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