Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Joining multiple tables
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
2 ORK766
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