select A.*,case when (select count(*) from tb_jc_xz B where A.parentid = B.uid) >0
then cast((select B.mc from tb_jc_xz B wh
ere A.parentid = B.uid) as VARCHAR)+'-'+A.mc else A.mc end as id from tb_jc_xz A
版权声明：本文为sinat_28238111原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。