On Jul 23, 2013, at 6:28 PM, Yaw Boakye elGran <yawboaky...@gmail.com> wrote:

>       • During grouping, the normal SQL requirement is to group on a column 
> that is on both tables. As far as I know, grouping can't be done on two 
> tables when they don't a common column. In your group call, only titles.id 
> would be useful. The rest won't

You seem to be confusing the grouping with the join condition. The join 
requires 1 (usually, sometimes more) column common to both tables. The grouping 
must include all columns not used in the aggregate function.


-- 
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice




-- 
You received this message because you are subscribed to the Google Groups "Ruby 
on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rubyonrails-talk+unsubscr...@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rubyonrails-talk/4F79E8C6-3BB4-4FE0-A64C-7B55C92DF4E8%40elevated-dev.com.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to