根据条件关联查询，拼接某个字段所有值

select sitecode,listagg(ammetertype,',') within GROUP (order by ammetertype) ammetertype from 
   (select distinct t1.sitecode,t2.ammetertype from tb_tres_sititenement t1 left join tb_tres_sitemachineroom t2 on t1.sitecode=t2.sitecode)
   WHERE SITECODE ='210602908001900005'

        group by sitecode