一个有意思的SQL问题

有两个表，一主一子。
主表order:

orderid    ordertype
1          A
2          B

子表（order_car):
orderid    carno
1          10
1          20
2          30

我想写一条select 语句，得到如下效果 ：

orderid    ordertype    carno
1          A            10,20
2          B            30

不写存储过程，能否实现？

---

行合并，交给77

---

try
SQL code:
select
a.orderid,
a.ordertype,
carno=stuff((select ','+ltrim(b.carno) from order_car where orderid=b.orderid),1,1,'')
from
[order] a
join
order_car b
on
a.orderid=b.orderid
group by
a.orderid,
a.ordertype

---

引用

try
SQL codeselect
  a.orderid,
  a.ordertype,
  carno=stuff((select','+ltrim(b.carno)from order_carwhere orderid=b.orderid),1,1,'')from[order] ajoin
  order_car bon
  a.orderid=b.orderidgroupby
  a.orderid,
  a.