Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SubQuery Question

Re: SubQuery Question

From: Tom <mail_at_yahoo.com>
Date: Fri, 18 Feb 2005 10:45:48 +0100
Message-ID: <cv4dg5$2t4$1@ls219.htnet.hr>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US