select * from(从XXX选择XXX)作为内连接(从xx选择xxxx) b a.xx=b。xx
select * from(选择id、pid、khdm khmc从com_base_kehu khdm2=DHB003)左加入(选择一个。id作为序号、a.org_id a.yhzdmc, b.pid, b.id, b.zd_id, c.khmc从ipos_yhzdz内连接ipos_yhzdzmx b a.id=b。pid内连接在b.zd_id com_base_kehu c=c。Id, a.org_id=' 3386 ',) b a.Id=b.zd_id
