ActiveRecord scope with advanced condition

Rails
1

Hi there,

Anyone knows how to use a scope with a table alias condition like:

SELECT *

FROM table_name
AS alias_name, alias_name2
Where alias_name.field = alias_name2.field

Or if anyone has other suggestion…

Thank you

2

Maybe this is the sort of thing you’re looking for?

–
Chris
http://livingsocial.com | http://clabs.org

3

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”)