谁一开始就是大神?

yii2mysql如何跨数据库联表查询?[2.0]

yii2 mysql如何跨数据库联表查询?
我这样写好像不行啊

 $query = (new Query())->from('vip as ccv');
        $query->leftJoin(\Yii::$app->get('db').'user as u','ccv.phone = u.user_mobile_phone');
        $query->leftJoin(\Yii::$app->get('db').'applet as uah','uah.user_id = u.user_id');
        $query->leftJoin(\Yii::$app->get('db').'grade as cvg','uah.level = cvg.vip_id');

        if (isset($condition['mobile']) && $condition['mobile'] != '') {
            $query->andWhere(['=', 'mobile', $condition['mobile']]);
        }

你先在数据库上写出来这种的sql试试就知道了
哦 这样啊 阿亮吃饭了没

赞(0) 打赏
未经允许不得转载:菜鸟之家 » yii2mysql如何跨数据库联表查询?[2.0]

评论 抢沙发

登录

找回密码

注册