select a.incode,a.inname,count(c.stzt) as stzt from
industry_infor as a left jion workType_infor as b on a.incode=b.incode
left jion exam_lltk_infor as c on b.workTypeCode = c.workTypeCode
group by a.incode,a.inname
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024