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.