select * from (select XXX from XXX) as a inner join(select xxxx from xx) as b where a.xx=b.xx

創(chuàng)新互聯(lián)建站堅(jiān)持“要么做到，要么別承諾”的工作理念，服務(wù)領(lǐng)域包括：成都網(wǎng)站設(shè)計(jì)、成都網(wǎng)站建設(shè)、企業(yè)官網(wǎng)、英文網(wǎng)站、手機(jī)端網(wǎng)站、網(wǎng)站推廣等服務(wù)，滿足客戶于互聯(lián)網(wǎng)時代的梧州網(wǎng)站設(shè)計(jì)、移動媒體設(shè)計(jì)的需求，幫助企業(yè)找到有效的互聯(lián)網(wǎng)解決方案。努力成為您成熟可靠的網(wǎng)絡(luò)建設(shè)合作伙伴！

select * from (select id,pid,khdm,khmc from com_base_kehu where khdm2='DHB003')as a left join (select a.id as 序號,a.org_id,a.yhzdmc,b.pid,b.id,b.zd_id,c.khmc from ipos_yhzdz a inner JOIN ipos_yhzdzmx b on a.id=b.pid INNER JOIN com_base_kehu c on b.zd_id=c.Id where a.org_id='3386'  ) as b on a.Id=b.zd_id