TP的这个Model是不是没处理好?

浏览:640 发布日期:2015/01/22 分类:求助交流
$subQuery = $dao->field("u.*,ub.aaa")
                            ->alias("as u")
                            ->join($relationType.' __USER_BIND__ AS ub ON u.id = ub.user_id')
                            ->where($where)
                            ->group("u.id")
                            ->select(false);
会这个效果:(加了两次别名,报错)
SELECT COUNT(*) AS tp_count FROM ( SELECT u.*,ub.aaa FROM ly_user as u as u LEFT JOIN ly_user_bind AS ub ON u.id = ub.user_id GROUP BY u.id ) as tmp LIMIT 1


另一种写法:(解决)        
$subQuery = $dao->table("__USER__ AS u ")->field("u.*,ub.aaa")
        ->join($relationType.' __USER_BIND__ AS ub ON u.id = ub.user_id')
        ->where($where)
        ->group("u.id")
        ->select(false);
SELECT COUNT(*) AS tp_count FROM ( SELECT u.*,ub.aaa FROM ly_user AS u LEFT JOIN ly_user_bind AS ub ON u.id = ub.user_id GROUP BY u.id ) as tmp LIMIT 1
最佳答案
评论( 相关
后面还有条评论,点击查看>>