Using INTERSECT in Base find

Hi Everyone,

I am having a bit of trouble figuring out how to use the SQL INTERSECT
command within a find.

I have been using find_by_sql but it doesn't play nicely with
with_scope so I need to get it into a normal find query.

Is this possible or do I need to do the intersection in rails instead
of the database? (or manually apply the scope to the find_by_sql query)

thanks,
Bob