ActiveRecord scope with advanced condition

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

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

http://guides.rubyonrails.org/association_basics.html#self-joins

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: