Shulou(Shulou.com)06/01 Report--

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

Select * from (select id,pid,khdm,khmc from com_base_kehu where khdm2='DHB003') as a left join (select a.id as serial number, a.orgpaperidrect a.yhzdmc as b on a.Id=b.zd_id. KHMC from ipos_yhzdz an inner JOIN ipos_yhzdzmx b on a.id=b.pid INNER JOIN com_base_kehu c on b.zd_id=c.Id where a.orgpaperidwriting 3386')

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.