Subquery Question

From: Paul Izzo <paul.izzo_at_mosca-ag.com>
Date: 18 Feb 2005 01:12:01 -0800
Message-ID: <1108717921.003641.33470@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. Received on Fri Feb 18 2005 - 03:12:01 CST