[Rails] Re: :joins VS :include => different results?

> A.find(:all, :conditions => 'a.column=1 AND b.column=2', :include => > 'b') # join And if you say "join", you mean a "LEFT join" here, if I got the story right... Thanks, guys! -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google G

[Rails] Re: :joins VS :include => different results?

IME :include does a join if you are using the 'included' table in the query conditions: A.find(:all, :conditions => 'a.column=1', :include => 'b') # no join A.find(:all, :conditions => 'a.column=1 AND b.column=2', :include => 'b') # join On Jun 2, 3:14 pm, Tom Ha wrote: > > :joins does an inner

[Rails] Re: :joins VS :include => different results?

> :joins does an inner join, :include doesn't (and may not even do a > join at all) If you say "may not", when would it do or not do a join, then? And which type of join? Doesn't :include amount to a LEFT JOIN, actually? -- Posted via http://www.ruby-forum.com/. -- You received this message

[Rails] Re: :joins VS :include => different results?

On Jun 2, 5:09 pm, Tom Ha wrote: > Question: Is it correct that: > - in case A), the books containing pages WITHOUT any illustrations will > NOT show up in the results > - whereas in case B), these books WILL show up? > > (Personally, I thought that the main difference between :joins and > :inc