[Rails] Re: Inner SELECT-s in Rails

Depends on how you layout your models. Things like "left join my_other_table on my_other_table.forein_key_id = my_table.id" are taken care of by AR if you set up the associations properly. You could then do a Model.count(:joins=>..., :conditions=>) On Jun 4, 12:38 am, Fernando Perez wrote

[Rails] Re: Inner SELECT-s in Rails

Roland Mai wrote: > here you go: > > select count(*) > from (select distinct field_id from my_table > left join my_other_table on my_other_table.forein_key_id = > my_table.id > where field_id < 5) as a > left join some_other_table on a.other_id = some_other_table.id > where some_oth