Brad Symons wrote: Try @result = Resulttypes( :all, :conditions => ['id in ( select result_id from outcomes o1 where o1.outcome_date = (select max(o2.outcome_date) from outcomes o2 where o2.testcase_id = o1.testcase_id and o1.testcase_id =\'1\'))']
This should work, I am doing seomthing similiar only I am say 'NOT IN.' -- 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 -~----------~----~----~----~------~----~------~--~---
