SQL:SELECT `f`.`xn`,`f`.`xq`,`f`.`gh`,`j`.`xm`,`k`.`kmmc`,`k`.`mc`,`f`.`nj`,`f`.`bj`,`f`.`ks` FROM `kcfpb` `f` INNER JOIN `jsjbxx` `j` ON `f`.`gh`=`j`.`gh` INNER JOIN `kcml` `k` ON `f`.`km`=k.kmbh or f.kc=k.kcbh WHERE `f`.`xn` = '2018' AND `f`.`gh` = '2906350021' GROUP BY `f`.`id`
$list=Db::table('kcfpb')
->alias('f')
->join('jsjbxx j','f.gh = j.gh')
->join('kcml k','f.km = k.kmbh or f.kc=k.kcbh')
->where($equment)
->group('f.id')
->field('f.xn,f.xq,f.gh,j.xm,k.kmmc,k.mc,f.nj,f.bj,f.ks')
->select();但是不知道在模型里面怎么实现。请高手们帮我写一下这个查询的模型操作。谢谢。 最佳答案