ThinkPHP聯表查詢

標籤：表名   where   查詢   nbsp   use   res   欄位   bsp   php   

1、table 方法

　　

　　原生sql方法

　　原生sql文法：select 表1.欄位,表2.欄位 from 表1as 別名1,表名2 as 別名 2 where 表1.欄位 = 表2.欄位;

　　select t1.*,t2.name as deptname from sp_user as t1,sp_dept as t2 where t1.dept_id = t2.id;

 

　　$model -> table(‘表名1[as 別名1],表名2[as 別名2]……‘);

　　$result = $model -> field(‘t1.*,t2.name as deptname‘) -> table(‘sp_user as t1,sp_dept as t2‘) -> where(‘t1.dept_id = t2.id‘) -> select();

2 、join方法

　　select 表1.欄位，表2.欄位 from 表1 as 別名[inner/left/right] join 表2 as 別名 on 表1.欄位 = 表2.欄位;

　　原生的sql：select t1.*,t2.name as deptname from sp_dept as t1 left join sp_dept as t2 on t1.pid;

ThinkPHP聯表查詢