Thanks, this is just what I wanted. > a subselect like this is usually better written as a join (which is > probably what the db does behind the scenes ie > SELECT products.* from products > inner join locations on locations.id = location_id > where address like '%foo%' > > which will be produced by Product.find :all, :joins > => :location, :conditions =>"address like '%foo%'" > > Fred
-- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
