CREATE OR REPLACE VIEW V_CSRY1 AS
select t."CASEID",
(SELECT wmsys.wm_concat(distinct(to_char(USERNAME))) FROM V_CSRY where caseid =t.caseid ) USERNAME,
(SELECT wmsys.wm_concat(distinct(to_char(DEPARTMENTNAME))) FROM V_CSRY where caseid =t.caseid ) DEPARTMENTNAME,
(SELECT wmsys.wm_concat(distinct(to_char(MOBILE))) FROM V_CSRY where caseid =t.caseid ) MOBILE
FROM ins_caseinfo t;
SQL-视图套娃写法
最新推荐文章于 2022-07-19 17:41:12 发布