From: Isti Blasko <istiblasko@...>
Date: 2011-09-17T00:53:57+09:00
Subject: Joining an array with a table

Hey

I am pretty new to Ruby 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/.