Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Joining multiple tables
Alk wrote:
> 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
Go to Morgan's Library at www.psoug.org
Click on Joins
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Tue Jun 12 2007 - 10:31:40 CDT