Rails的ActiveRecord的：加入与LEFT JOIN，而不是INNER JOIN [英] Rails ActiveRecord :joins with LEFT JOIN instead of INNER JOIN

问题描述

我有这个code

User.find(:all, :limit => 10, :joins => :user_points,
                :select => "users.*, count(user_points.id)", :group =>
                "user_points.user_id")

这会产生以下SQL

which generates following sql

SELECT users.*, count(user_points.id) 
FROM `users` 
INNER JOIN `user_points` 
ON user_points.user_id = users.id 
GROUP BY user_points.user_id 
LIMIT 10

是有可能使LEFT JOIN，而不是INNER JOIN的其他方式比 User.find_by_sql 和manualy输入查询？

is it possible to make LEFT JOIN instead of INNER JOIN other way than User.find_by_sql and manualy typing the query?

推荐答案

您可以试试这个

User.find(:all, limit: 10,
            joins:  "LEFT JOIN `user_points` ON user_points.user_id = users.id" ,
            select: "users.*, count(user_points.id)", 
            group:  "user_points.user_id")

这篇关于Rails的ActiveRecord的：加入与LEFT JOIN，而不是INNER JOIN的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！