SQL-视图套娃写法

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;