;with t as( select a.NY,a.JH as JH1,b.JH as JH2 from kf_ddd01 a inner join kf_ddd02 b on a.NY=b.NY ) select NY, JH1=stuff( (select ','+JH1 from t b where a.NY=b.NY for xml path('')), 1, 1, ''), JH2=stuff( (select ','+JH2 from t c where a.NY=c.NY for xml path('')), 1, 1, '') from t a
select a.*, jh1=stuff((select ','+jh from tb1 where ny=a.ny for xml path('')),1,1,''), jh2=stuff((select ','+jh from tb2 where ny=a.ny for xml path('')),1,1,'') from (select ny from tb1 union select ny from tb2) a
;with t
as(
select a.NY,a.JH as JH1,b.JH as JH2
from kf_ddd01 a
inner join kf_ddd02 b
on a.NY=b.NY
)
select
NY,
JH1=stuff(
(select ','+JH1
from
t b
where
a.NY=b.NY
for xml path('')), 1, 1, ''),
JH2=stuff(
(select ','+JH2
from
t c
where
a.NY=c.NY
for xml path('')), 1, 1, '')
from t a
jh1=stuff((select ','+jh from tb1 where ny=a.ny for xml path('')),1,1,''),
jh2=stuff((select ','+jh from tb2 where ny=a.ny for xml path('')),1,1,'')
from (select ny from tb1 union select ny from tb2) a
这里既不是Oracle 也不是Mysql