Re: Subquery Question

In message <1108717921.003641.33470_at_z14g2000cwz.googlegroups.com>, Paul Izzo <paul.izzo_at_mosca-ag.com> writes
>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.
>

Is this homework?

Look at the HAVING clause.

-- 
Jim Smith
Because of their persistent net abuse, I ignore mail from
these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw
For an explanation see <http://www.jimsmith.demon.co.uk/spam>