has_many through. How to form find

I have this tipical has_many :through scenario:

class Docs < ActiveRecord::Base   has_many :doc_cats   has_many :categories, :through => :doc_cats end

class Categories < ActiveRecord::Base    has_many :doc_cats    has_many :docs, :through => :doc_cats end

class Doc_cats < ActiveRecord::Base   belongs_to :docs   belongs_to :categories end

Now I would like to get all docs which have (belong to) categories 2 and 4. How to specify find clouse?

@docs = Docs.find(:all, .......... etc)

by TheR

i did not tried on console, but is something like this:

@docs = Doc.find(:all, :include => [:doc_cats], :conditions => 'doc_cats.category_id in [2,4]')

Damjan Rems wrote:

flaubert wrote:

i did not tried on console, but is something like this:

@docs = Doc.find(:all, :include => [:doc_cats], :conditions => 'doc_cats.category_id in [2,4]')

Thank you very much. It works.

Of course I had to update table mames.

by TheR