Help with a SQL Query

From: Alk <alkkmrz2004_at_yahoo.com>
Date: Tue, 12 Jun 2007 15:29:02 -0000
Message-ID: <1181662142.712984.146130@q19g2000prn.googlegroups.com>

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 Received on Tue Jun 12 2007 - 10:29:02 CDT