效果图
select
wmsys.wm_concat(mc.CARD_ID) CARDIDS,
mt.DESCR,
mt.MODEL_ID,
mt.RATIO,
wmsys.wm_concat(bt.name) cardName,
mt.CREATED_AT,
mt.UPDATED_AT,
mt.CREATOR_ID,
mt.UPDATOR_ID
from MOD_WB_PARAMS_TB mt
left join MOD_WB_PARAMS_CARD_TB mc on mt.id = mc.WB_CARD_ID
left join BAS_CARD_TB bt on mc.CARD_ID = bt.ID
where mt.MODEL_ID = ‘ ’
group by
mt.id,
mt.DESCR,
mt.MODEL_ID,
mt.RATIO,
mt.CREATED_AT,
mt.UPDATED_AT,
mt.CREATOR_ID,
mt.UPDATOR_ID
order by mt.id
使用此函数把数据不同的列整合为一条数据