一个产品多个价格的查询语句！

[电子元器件]

各位大侠
　表1:tblProduct(ID,PartNo,Brand)
1,aaaa,brand1
2,bbbb,brand2
3,ccccc,brand3
表2:tblPrice(ID,ProductID,Qty,Price)
1,1,10,2.5
2,1,20,2.3
3,1,30,2.2
4,2,10,42
5,2,20,40

请问这两个表怎样选出如下的数据呢？
https://img-bbs.csdn.net/upload/201409/05/1409878186_582832.png

[freecodex]

您期待的结果和测试数据不同样例不同，不是很理解您要的结果

[Tiger_Zhao]

WITH tblProduct(ID,PartNo,Brand) AS (
    SELECT 1,'aaaa','brand1' UNION ALL
    SELECT 2,'bbbb','brand2' UNION ALL
    SELECT 3,'ccccc','brand3'
),
tblPrice(ID,ProductID,Qty,Price) AS (
    SELECT 1,1,10,2.5 UNION ALL
    SELECT 2,1,20,2.3 UNION ALL
    SELECT 3,1,30,2.2 UNION ALL
    SELECT 4,2,10,42 UNION ALL
    SELECT 5,2,20,40 
)
  SELECT t1.PartNo,
         t1.Brand, 
         Convert(varchar(11),t2.Qty)+'+' Qty,
         Price
    FROM tblProduct t1
    JOIN tblPrice t2
      ON t2.ProductID = t1.ID
ORDER BY t1.ID, t2.Qty

PartNo Brand  Qty                                            Price
------ ------ ------------ ---------------------------------------
aaaa   brand1 10+                                              2.5
aaaa   brand1 20+                                              2.3
aaaa   brand1 30+                                              2.2
bbbb   brand2 10+                                             42.0
bbbb   brand2 20+                                             40.0

剩下的单元格合并、Price的显示格式，要由表格控件来完成。