求一个SQL,对你来说很简单的,thanks
我使用以下查询SQL得到以下结果,
SELECT o.submitid,c.paystatus
FROM orderdetailsubmit o RIGHT JOIN customercard c ON c.submitid=o.submitid;
+---------------+-----------+
| submitid | paystatus |
+---------------+-----------+
| 1181870193984 | 2 |
| 1181870193984 | 3 |
+---------------+-----------+
以下是我想得到的结果,就是submitid重复的情况,要把paystatus 的值连接起来
+---------------+-----------+
| submitid | paystatus |
+---------------+-----------+
| 1181870193984 | 2 ,3 |
+---------------+-----------+
[解决办法]
SELECT o.submitid,concat(c.paystatus, ', ',p.paystatus)
FROM orderdetailsubmit o RIGHT JOIN customercard c ON c.submitid=o.submitid left join orderdetailsubmit p on o.submitid = p.submitid.
