JohnnyC wrote: > I'm sure this is not a new topic -- I've read mention of it elsewhere > -- but in addition to :joins => :profile, Active Record also > needs :inner_joins => :profile, :outer_joins => :profile, :left_joins > => :profile, and all the popular combinations of join types. > > I've got a sqlite development environment with mysql in production. > mysql says "what?" when it see LEFT OUTER JOIN.
That's probably not the actual issue. According to http://dev.mysql.com/doc/refman/5.0/en/join.html , LEFT OUTER JOIN is legal in MySQL. What errors are you actually getting? Best, -- Marnen Laibow-Koser http://www.marnen.org [email protected] -- Posted via http://www.ruby-forum.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.

