Rails - Mar 2006 - How to use: INNER JOINS & IN

Hi
 
I am not clear about how to use INNER JOINS and IN(...) sub query in rails. Is
there a good tutorial which helps newbies step by step ?
 
I have a 
 
model Library
model Authors
model Fictions
 
The relation maybe explained as:
 
Library has many fiction books
authors have many fictions
 
The authors table has information like full name, period of life, country etc.
 
In that case, I want to select fictions from library, where the authors are from
countries US and FRANCE
 
Thanks
 
R
_________________________________________________________________
Because e-mail on your cell phone should be easy:  Try Windows Live Mail for
Mobile beta
http://www2.imagine-msn.com/minisites/mail/Default.aspx?locale=en-us
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://wrath.rubyonrails.org/pipermail/rails/attachments/20060306/ab850f01/attachment.html