发布时间:2023-03-05 04:20来源:www.sf1369.com作者:宇宇
比如你有两个表 pre_first pre_second 并且你数据库配置文件已经配置了表前缀那么你可以这么写
$First=new \Think\Model(First);
//联表查询条件
$arrJoin=array(
__SECOND__ as s on f.id=s.id ,
);
$list=$First->alias('f')->join($arrJoin,'LEFT')->select();
不需要循环查询,做一次联表查询就可以了;
$data = M()->table('project a')->join('project_sub b on b.project_id = a.id')->field('a.id as aid, a.name, b.id as bid,b.title');
SELECT A.XXXID,C.XXXDESC,A.XXXCODE,B.XXXDM,A.XXXXSC,A.TEL,A.STAUTS,B.ZT
FROM XXX.表名 B
JOIN X.表名 A ON A.XXXCODE=B.XXXDM
AND
A.STAUTS<>(CASE WHEN B.ZT=0 THEN 0 ELSE 1 END )
LEFT JOIN XX.表名 C ON A.XXXID=C.XXXid
ORDER BY 1;