3,491
社区成员
发帖
与我相关
我的任务
分享
select a.bdsbh || a.xlbh || a.tqbh, tqmc, byqlxmc, null
from tq_cx a
left join (select (e.bdsbh || e.xlbh || e.tqbh) xlid, byqlxmc
from da_byqsb_dab c
join tq_cx e on e.tqid = c.yhid
join sys_byqxhcsb d on c.byqcs_lxbh = d.byqlxbh) b on a.bdsbh ||
a.tqbh =
b.xlid