Displaying 1 result from an estimated 1 matches for "outer_joins".
2006 May 07
1
Find records not in join with has_many_and_belongs_to
...= ?", @user.id],
:conditions => ["topics_users.topic_id is null"])
This would be nice too, to get rid of some of the SQL and be able to
specific a table to outer join and then send it some conditions:
@user = User.find(params[:id])
@topics = Topic.find(:all,
:outer_joins => ["topic_users", ["user_id = ?", @user.id]],
:conditions => ["topics_users.topic_id is null"])
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060507/dccd922f/attac...