select a.did,a.dname,a.dtel,a.detailed,(select replace(WMSYS.WM_CONCAT(b.ocode),',',',') from tdc_order b where b.dtel='15919941706' and b.ostate in(0,1)) ocode from tdc_diners a where a.dtel='15919941706'
oracle把查出来列结果集用逗号隔开一行显示
最新推荐文章于 2024-08-12 16:38:37 发布