where条件要写在join之后
/**
* 提现申请
*/
public function list1Action()
{
//////三表联合查询$Model = M('T1');$Model->join('t2 on t1.id = t2.uid', 'left')->join('t3 on t2.uid = t3.sid', 'left')->select();
// 考虑分页
$pagesize = 10;
$page = I('get.p', '1');
$m_tixian = M('Tixian');
// 通用查询条件
$cond['lb_tixian.status'] = '1';
$tixian_list = $m_tixian
->table('lb_tixian')
->join("LEFT JOIN lb_user ON lb_tixian.openid = lb_user.openid")
->join("LEFT JOIN lb_bank ON lb_tixian.bankid = lb_bank.id")
->where($cond)
->field('lb_tixian.*,lb_user.name as name,lb_user.phone as phone,lb_user.idnumber as idnumber,lb_bank.bank as bank,lb_bank.banknum as banknum')
->order('id desc')
->page($page, $pagesize)
->group('id')
->select();
echo $m_tixian->getLastSQL();
连接查询举例:
原始数据:
Paste_Image.png
Paste_Image.png
1:找出索尼4G手机所属类别名称:
Paste_Image.png
2,找出所有属于手机数码的产品:
Paste_Image.png