Re: Joining multiple tables

Hello Daniel

      Thank you for the link,

      However I am having a problem in aggregation when grouping products as in the below example, Any additional clues will be very helpful.

Thx
Alk
DA Morgan wrote:
> 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:53:16 CDT