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 19:10:56 -0700
Message-ID: <1181700654.711308@bubbleator.drizzle.com>


tommaso.gastaldi_at_uniroma1.it wrote:

> On 12 Giu, 17:25, Alk <alkkmrz2..._at_yahoo.com> 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
> 
> If you want, you can use this visual tool which creates the queries
> for you:

Please do not use (MISUSE) this forum to promote your for-profit venture. And GUI tools do not provide learning ... they provide the appearance of learning.

-- 
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 - 21:10:56 CDT

Original text of this message

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