我有这段代码
User.find(:all, :limit => 10, :joins => :user_points,
:select => "users.*, count(user_points.id)", :group =>
"user_points.user_id")
生成以下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
除了使用User.find_by_sql
并手动键入查询之外,是否有其他方法可以使LEFT JOIN替代INNER JOIN?
WHERE user_points.user_id IS NULL
,对吧? - Bernardo Loureiro