Also http://guides.rails.info/finders.html ----- Ryan Bigg Freelancer http://frozenplague.net
On 04/12/2008, at 3:53 PM, Teedub wrote: > > I think you can find that answer here: > > http://railscasts.com/episodes/3-find-through-association > > On Dec 3, 7:43 pm, Jay Mark <[EMAIL PROTECTED]> wrote: >> I am using Rails 2.0.2 with mysql >> database >> >> I have two tables: book and author >> Table book has 3 columns: id, isbn, and title >> Table author has 3 columns: id, name, and age >> >> In the models I have: >> class Book < ActiveRecord::Base >> belongs_to :author >> end >> >> class Author < ActiveRecord::Base >> has_many :books >> end >> >> I have author_id as the foreign key in the book's table >> >> The user will select 'age' from a list >> Then I want to display names of all authors with the selected age, >> and also the 'title' from book's table. >> >> In plain SQL, the query will be like this: >> >> SELECT name, title >> FROM author >> INNER JOIN book >> ON author.id = book.id >> WHERE age = "the selected age" >> >> How can I write this in Ruby? >> >> Thanks >> Cypray >> -- >> Posted viahttp://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 -~----------~----~----~----~------~----~------~--~---
