Tuesday, April 10, 2012

[Rails] Re: ActiveRecord scope with advanced condition

Hi there Chris, i already found a solution, but thanks anyway. I need
to check from 2 table entries where they have a field in common.

Here's the snippet:

> User.from("Users as u1, Users as u2).where("u2.LastName=u1.LastName AND u1.id != u2.id")


On 9 Abr, 19:38, Chris Morris <chri...@clabs.org> wrote:
> Maybe this is the sort of thing you're looking for?
>
> http://guides.rubyonrails.org/association_basics.html#self-joins
>
> --
> Chrishttp://livingsocial.com|http://clabs.org

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home


Real Estate