Re: Subquery Question

From: Haximus <e_at_t.me>
Date: Sun, 20 Feb 2005 10:28:05 GMT
Message-ID: <VCZRd.23520$AO.13799@clgrps12>

"Paul Izzo" <paul.izzo_at_mosca-ag.com> wrote in message news:1108717921.003641.33470_at_z14g2000cwz.googlegroups.com...
>I have 2 tables that contain Schedule information. The first table
> contains Work Order's and the second table contains Task information.
>
> A given Work Order is composed of any combination of Tasks. Example:
>
> Work Order = Car
> Task 1 = Wheel Install
> Task 2 = Wheel Install
> Task 3 = Wheel Install
> Task 4 = Wheel Install
>
> What I'm looking for is a way to find all Work Orders that contain only
> 4 tasks. There's no feild in the tables that specify how many Tasks are
> part of a Work Order.
>
> I have the feeling in my gut that I need to do this query using a
> subquery. My only problem is that I don't know how to filter out Work
> Orders with less than 4 Tasks as well as those with more than 4 Tasks.

You don't need a subquery, just use a left join, group by Work Order PK, and use the count(*) function along with a HAVING clause Received on Sun Feb 20 2005 - 04:28:05 CST