Rails - Sep 2011 - joining and array with a table in ActiveRecord

Hey

I am pretty new to Ruby on Rails and I have no idea how to solve the
following:

I have a join query on a table like this:

  def mytags
    Taggable.joins("JOIN taggables as filter ON taggables.tag_id
filter.tag_id WHERE filter.taggable_type = ''User'' AND
filter.taggable_id
= 1").all
  end

this works perfectly fine.
then I want to join the result on another table, where
OtherTable.joins(@mytags) works also fine BUT I want to
join on two other colums and NOT on the ids....

Can anyone tell me how to do this?
thx

-- 
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.