Ò»¸öÓÐÒâ˼µÄ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.