Question

mysqli中三表联合查询怎么弄

cc_com,cc_user,cc_dd三个表，cc_com中的comid和cc_dd中的comid一样，cc_dd中的userid和cc_user中的userid一样，要查询出username、conname、ddid、shr。





Answer 1

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