关于1对多查询
方法一:通过to_char(wm_concat(列名)) 再后台解析数据
SELECT
DISTINCT
t.ID,
to_char(wm_concat(t.SUPPLIER_ENCLOSURE_FILE_ID)) as LINK_SUPPLIER_FILE_ID,
to_char(wm_concat(t.EXPERT_ENCLOSURE_FILE_ID)) as LINK_EXPERT_FILE_ID,
to_char(wm_concat(t.SUPPLIER_ENCLOSURE_NAME)) AS SUPPLIER_ENCLOSURE_NAME_ARR,
to_char(wm_concat(t.EXPERT_ENCLOSURE_NAME)) AS EXPERT_ENCLOSURE_NAME_ARR
FROM
(
SELECT
a.ID,
a.ISSUE_ID,
a.REQUIRED_TEST_UNIT,
a.SUB_RECTIFICATION_ID,
a.ROUND,
a.SELECT_STATUS,
a.EXPERT_DESC,
a.ARRANGED_EXPERT_ID,
a.CHECK_STATUS,
a.REMARK,
a.CREATE_USER,
a.SUB_DETAIL_ID,
a.OTHER_REASON,
a.CREATE_TYPE,
a.QUALITY_PROMISE,
a.SERVICE_PROMISE,
a.DELIVERY_PROMISE,
a.INTEGRITY_PROMISE,
b.REASON_NAME,
c.SECOND_DESC,
c.SOLUTION_NAME,
c.SUPPORT_DESC,
d.ENCLOSURE_NAME as SUPPLIER_ENCLOSURE_NAME,
d.ID as SUPPLIER_ENCLOSURE_FILE_ID,
d.ENCLOSURE_CONTENT as SUPPLIER_ENCLOSURE_CONTENT,
f.ENCLOSURE_NAME as EXPERT_ENCLOSURE_NAME,
f.ID as EXPERT_ENCLOSURE_FILE_ID,
f.ENCLOSURE_CONTENT as EXPERT_ENCLOSURE_CONTENT
FROM
W.IO_MATCH a
LEFT JOIN W.IO_SUB_RECTIFICATION b ON a.SUB_RECTIFICATION_ID = b.ID
LEFT JOIN W.IO_SUB_DETAIL c ON a.SUB_DETAIL_ID = c.ID
LEFT JOIN W.IO_ISSUE s ON s.UUID = a.ISSUE_ID
left JOIN W.IO_ENCOSURE d ON d.ISSUE_ID = a.ID AND d.ENCLOSURE_TYPE = '3'
LEFT JOIN W.IO_ENCOSURE f ON f.ISSUE_ID = a.ID AND f.ENCLOSURE_TYPE = '4'
WHERE
a.ISSUE_ID = 'issue0001'
AND a.round = s.round
) t
GROUP BY t.ID
方法二:
参考:https://www.cnblogs.com/longxok/p/10905975.html
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 微软正式发布.NET 10 Preview 1:开启下一代开发框架新篇章
· 没有源码,如何修改代码逻辑?
· PowerShell开发游戏 · 打蜜蜂
· 在鹅厂做java开发是什么体验
· WPF到Web的无缝过渡:英雄联盟客户端的OpenSilver迁移实战