I have this query, I have tried a few permutations to translate it into a :find equivalent, as a newbie this is a bit trickier than i first envisaged.
heres the core sql: select resulttype from results where 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')); can you give me a few pointers, does it require a join clause from the results table to the outcomes, or can rails do this easier? -- 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 -~----------~----~----~----~------~----~------~--~---
