tbA
col1 col2
A001 aaa
A002 bbbtbB
col3 col4
A001 111
A001 222
A001 333
A002 444
A002 555得到的表样式为:
tbC
col1 col2 col4
A001 aaa 111,222,333
A002 bbb 444,555怎么得到tbC样式.
col1 col2
A001 aaa
A002 bbbtbB
col3 col4
A001 111
A001 222
A001 333
A002 444
A002 555得到的表样式为:
tbC
col1 col2 col4
A001 aaa 111,222,333
A002 bbb 444,555怎么得到tbC样式.
on a.col1=b.col1
group by a.col1,a.col2
from tbA ,tbB
where tbA.col1=tbB.col3
group by col1
on a.col1=b.col3
group by a.col1,a.col2
FROM tbA ,tbB
WHERE tbA.col1=tbB.col3
GROUP BY col1;
from tbA ,tbB
where tbA.col1=tbB.col3
group by col1