Work order = A Car=B
select * from A,B
where /*use correct join*/
rownnum <= 4
order by Task1
"Paul Izzo" <paul.izzo_at_mosca-ag.com> wrote in message
news:1108718025.848350.221450_at_l41g2000cwc.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:45:48 CST
