这个SQL语句怎么写？

one表
id  name
1    移动
2    电信
3    联通

two表
oneid  price
1      4000.00
3      200.00
3      5000.00

结果
编号  名称  价格
1      移动  4000.00
2      电信  0.00
3      联通  5000.00

---

結果3 為什麼不是5200.00?

---

SQL code:
SELECT ONE.ID,ONE.[NAME],TWO.PRICE
from ONE
INNER JOIN TWO ON ONE.ID=TWO.ONEID

---

看错了。。水哥说的对

---

SQL code:
select a.*,
sum(isnull(b.price,0))
from one a left join two b
on a.id=b.oneid
group by a.id , a.name

---

SQL code:
SELECT T1.ID,T1.[NAME],COALESCE(T2.MAXPRICE,0)
from ONE T1
LEFT JOIN (
SELECT ONEID,MAX(PRICE) 'MAXPRICE' from TWO --如果求和就是SUM
) T2 ON T1.ID=T2.ONEID

---

SQL code:
--> Title : Generating test data #one
--> Auth