# RoR-Sql query

**URL:** <https://discuss.rubyonrails.org/t/ror-sql-query/45874>\
**Category:** rubyonrails-talk\
**Created:** [September 8, 2009, 7:04am UTC](https://discuss.rubyonrails.org/t/ror-sql-query/45874 "2009-09-08T07:04:34Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Abhinav\_Saxena](https://avatars.discourse-cdn.com/v4/letter/a/4da419/32.png) [@Abhinav\_Saxena](https://discuss.rubyonrails.org/u/Abhinav_Saxena)\
**Post date:** [September 8, 2009, 7:04am UTC](https://discuss.rubyonrails.org/t/ror-sql-query/45874/1 "2009-09-08T07:04:34Z")

</div>

Well, I don’t know the answer, but you can probably use the sql query mentioned in this page: [http://www.keithjbrown.co.uk/vworks/mysql/mysql\_p5.php](http://www.keithjbrown.co.uk/vworks/mysql/mysql_p5.php) ( Do a browser search on string “Joining Three Tables”)

BTW, this email is to mention a different problem in your query: should not card be cards and book be books in your query (table names are, by convention, plural in rails) Try that too, might work.

Thanks, Abhinav