连贯查询先条件查询再左连接,MSSQL语句

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