高难度查询，请求帮助（急！急！）

有两个表如下：
产品基本资料表：
产品编号    产品名称     商品编号      消费国     单位      单价
1             AA          85131010       USA       PCS      10.18
2             BB          85131010       HONGKONG   PCS     9.15
3             CC          85121010       JAN        PCS     11.23
合同产品表：
合同号   产品编号   件料编号   件料名称     损耗      单耗
   38      1          1          A1           2       0.01
   38      1          2          A2           0       0.02
   38      1          3          A3           2       0.05
   38      1          10         A5           2       0.02
   38      2           1         A1           2       0.03
   38      2           8         A4           0       0.05
   38      2           3         A3           2       0.02
   38      2           5         A6           0       0.01
   38      3           2         A2           0       0.03
   38      3           5         A6           0       0.1
   38      3           10        A5           2       0.05
   38      3           8         A4           0       0.04
   38      3           3         A3           2       0.08现在要做一个查询，结果如下：
                       产品编号（1）        产品编号（2）        产品编号（3）  
件料编号   件料名称     单耗   损耗         单耗   损耗          单耗   损耗
1            A1           0.01    2          0.03     2           
2            A2           0.02    0                               0.03   0
3            A3           0.05    2          0.02     2           0.08   2
5            A6                               0.01    0           0.1    0
8            A4                               0.05    0           0.04   0     
10           A5           0.02    2                               0.05   2不够分再加,谢谢