I think what you are trying to do is joins
if your associations are set correctly, then something like below should
work
Site.joins(:snapshots).joins(:technologies).where("sites.id=1")
*Note: *in the where clause, you cannot use :id=>1 because :id with the
joined tables will be ambigious... you have to state explicitly the table
of which the id to be used
On Fri, Nov 11, 2011 at 2:02 PM, Mahmoud Abdel-Fattah <
[email protected]> wrote:
> I'm totally rails newbie, and just started it a couple of days ago
> moving from PHP, so I've the following query, and want to know how can
> I do it using ActiveRecord
>
> SELECT `sites`.*, `snapshots`.*, `technologies`.*
> FROM `sites`, `snapshots`, `technologies`
> WHERE `sites`.id = '1'
> AND `snapshots`.`site_id` = `sites`.`id`
> AND `technologies`.`snapshot_id` = `snapshots`.`id`
>
> --
> 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.
>
>
--
Mahmoud Said
Software Engineer - eSpace
blog.modsaid.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.
