日期:2014-05-16  浏览次数:20434 次

求一条产品销售量,包括产品属性参数的sql语句
第一步:现有数据如下,ProductId产品id, OrderId代表订单编号,ShipmentQuantity该产品的该订单的销售量,ValueId产品所属参数id, ValueStr产品参数名称,
ProductId            OrderId     ShipmentQuantity     ValueId     ValueStr     ProductName                                                                                                                                                                                            

45                   201403306241956          1                    72          M                  产品1                                                                                                                                                                                          
48                   201402195799492          2                    73          L                   产品2                                                            &n