Re: Joining multiple tables

I am appending to the email because the format got tangled

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
Line ID Order
Value
1001
500
1002
200

1003                 500

Table 3: Product Mapping
Product Group          Product Code
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:33:06 CDT