一对多查询只显示一条数据数据合并

最新推荐文章于 2024-06-17 20:44:56 发布

半颗心丶

最新推荐文章于 2024-06-17 20:44:56 发布

阅读量3.2k

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/dong281055686xin/article/details/49886823

版权

数据库专栏收录该内容

7 篇文章 0 订阅

订阅专栏

select a.apply_user,
	   a.apply_date,
	   a.apply_c,
	   to_char(wm_concat(a.modi_data)) modi_data,
	   a.vaid_user,
	   a.vaid_date,
	   a.vaid,
	   a.id
	   from (

SELECT
    (select u.fname from sys_user_info u where u.FID = his.APPLY_USER_ID) apply_user,
    to_char(his.APPLY_DATE,'yyyy-mm-dd') apply_date,
    to_char(his.APPLY_CONTENT) apply_c,
    data.MODI_DATA,
	(select u2.fname from sys_user_info u2 where u2.fid = his.VALID_USER_ID) vaid_user,
	to_char(his.VALID_DATE, 'yyyy-mm-dd') vaid_date,
	(case his.VALID when '0' then '不允许修改' when '1' then '允许修改' else '未批复' end) vaid,
	his.ID id
FROM
    work_modi_his his
	left join work_modi_data data on data.HIS_ID = his.ID
where
	data.MODI_DATA is not null
	--and his.ID = '2c9a40dd4ff85495014ff93a6e570491'
) a
group by a.apply_user,a.apply_date,a.apply_c,a.vaid_user,a.vaid_date,a.vaid,a.id