mysql - 按组条件附加 mysql 选择结果

Question

我正在制作一份报告，我需要通过将 cd.line_id 条件分组来加入多个表格以获取结果来总结结果。以下是我的选择查询。

SELECT bp.broadband_name,cd.line_id FROM broadband_service_master bp,dedint_account_services_table_wireless_pbx dp,
dedint_account_services_table das,dedint_account_table da,csr_deposit_change_history cd
 WHERE  bp.broadband_service_id=dp.service_id
 AND dp.dedint_service_table_id=das.id
 AND das.account_id=da.id
 AND cd.line_id=da.account_id
 GROUP BY cd.line_id

我得到这个：

broadband_name        line_id  
--------------------  ---------

Equipment Support        344065
OffNet Landline Call     344065
Excess ONNET Calls       344065
Equipment Support        344066
International Call       344066
OffNet Landline Call     344066
Unlmtd ONNET Call        344066

我需要这样的结果：

broadband_name                                             line_id  
--------------------                                      ---------

Equipment Support,OffNet Landline Call,Excess ONNET Calls    344065

Equipment Support,International Call ,OffNet Landline Call,Unlmtd ONNET Call 344066

标签： mysql

Answer 1

尝试这个..GROUP_CONCAT

SELECT GROUP_CONCAT(bp.broadband_name),cd.line_id FROM broadband_service_master bp,dedint_account_services_table_wireless_pbx dp,
dedint_account_services_table das,dedint_account_table da,csr_deposit_change_history cd
 WHERE  bp.broadband_service_id=dp.service_id
 AND dp.dedint_service_table_id=das.id
 AND das.account_id=da.id
 AND cd.line_id=da.account_id
 GROUP BY cd.line_id