Rails - Oct 2006 - 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


--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---