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

Home -> Community -> Usenet -> c.d.o.server -> Joining multiple tables

Joining multiple tables

From: Alk <alkkmrz2004_at_yahoo.com>
Date: Tue, 12 Jun 2007 15:25:21 -0000
Message-ID: <1181661921.034713.38050@i38g2000prf.googlegroups.com>


Hello,

   I am looking for help on building a query which joins about 3 tables to get the output as shown below,

        Any help is appreciated

Table 1: Order Line

Line ID            Order ID      ProductCode
1001                100             ORK100
1002                100             ORK766
1003                101             ORK233


Table 2: Order Line
Values
Table 3: Product Mapping
Line ID Order
Value
Product Group Product Code
1001
500

1                              ORK100

1002
200
2                              ORK766

1003
500
1                              ORK233

 Expected Output
Order ID          ProductGroup1       ProductGroup2
100                   500                            200
101                   500                             0

Thank You
Alk Received on Tue Jun 12 2007 - 10:25:21 CDT

Original text of this message

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