Re: Subquery Question

From: Dieter Nöth <dnoeth_at_gmx.de>
Date: Fri, 18 Feb 2005 10:57:34 +0100
Message-ID: <37lshdF5fnb92U1@individual.net>

Paul Izzo wrote:

> 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

Just remove the "and" before having.

Dieter Received on Fri Feb 18 2005 - 03:57:34 CST