I have to use subselect for this query. find_all_by_name and joins will not work. Please I need help with getting the correct syntax for doing subselect the rails way. The query works fine in mysql. I can't find the syntax in the docs or may be I was looking in the wrong place. My project is due tomorrow. Please help!!! Here is the query statement:
@books = Books.find_by_sql ["SELECT * FROM books WHERE title IN SELECT title FROM authors WHERE name = ?", params[:author][:name]] One problem is where to put the () that will enclose the inner select. Or may be it is not needed. Thanks Cypray. -- 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 -~----------~----~----~----~------~----~------~--~---
