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 -> Re: Joining multiple tables

Re: Joining multiple tables

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 12 Jun 2007 08:31:40 -0700
Message-ID: <1181662298.348256@bubbleator.drizzle.com>


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.org
Received on Tue Jun 12 2007 - 10:31:40 CDT

Original text of this message

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