mysql回行_Mysql返回多行

我有这个问题.

SELECT notes.id,enter.name as &＃39;enter_name&＃39;,step.title as &＃39;flow status&＃39;,notes.user_name as user_created,notes.created,notes.rel_client_id,td_doc_nr.value_string as &＃39;document number&＃39;,enter.enter_code,

IF(!ISNULL(td_doc_nr.value_string),

(SELECT GROUP_CONCAT(product_name SEPARATOR &＃39;,&＃39;) from notes d

join note_bundles b on b.note_id &＃61; d.id

join note_products p on p.doc_bundle_id &＃61; b.id

join note_product_get_fields f on f.doc_product_id &＃61; p.id

join note_product_get_field_data fd on fd.get_field_id &＃61; f.id

where d.doc_nr &＃61; td_doc_nr.value_string

and value_string &＃61;&＃39;auto&＃39;)

,NULL) as test

FROM notes notes

JOIN notes_steps step ON step.id &＃61; notes.step_id

JOIN notes_enters enter ON enter.id &＃61; notes.enter_id

LEFT JOIN notes_custom_fields tf_doc_nr ON tf_doc_nr.name &＃61; &＃39;note_number&＃39; AND tf_doc_nr.rel_entity_id &＃61; enter.id

LEFT JOIN notes_custom_field_data td_doc_nr ON td_doc_nr.rel_entity_id &＃61; notes.id AND

td_doc_nr.field_instance_id &＃61; tf_doc_nr.id

WHERE notes.enter_id in (777) AND notes.status &＃61; 1

我将此子查询添加到’if语句’

SELECT GROUP_CONCAT(product_name SEPARATOR &＃39;,&＃39;) from nontes d

join note_bundles b on b.note_id &＃61; d.id

join note_products p on p.doc_bundle_id &＃61; b.id

join note_product_get_fields f on f.doc_product_id &＃61; p.id

join note_product_get_field_data fd on fd.get_field_id &＃61; f.id

where d.doc_nr &＃61; &＃39;G7777777&＃39;

and value_string &＃61;&＃39;auto&＃39;

在此之后我添加了一个新专栏.

SELECT GROUP_CONCAT(product_name SEPARATOR &＃39;,&＃39;),GROUP_CONCAT(DISTINCT b.msisdn SEPARATOR &＃39;,&＃39;) from notes d

join note_bundles b on b.note_id &＃61; d.id

join note_products p on p.doc_bundle_id &＃61; b.id

join note_product_get_fields f on f.doc_product_id &＃61; p.id

join note_product_get_field_data fd on fd.get_field_id &＃61; f.id

where d.doc_nr &＃61; &＃39;G7777777&＃39;

and value_string &＃61;&＃39;auto&＃39;

它返回两列.

如何返回两列&＃xff1f;有可能吗&＃xff1f; &＃xff1a;) 谢谢