From: Gleb Mazovetskiy <glex.spb@...>
Date: 2009-10-25T04:15:00+09:00
Subject: Help with SQL -> associations (Multiple JOINs)

Is there a way to express this with associations?

    @songs = Song.find_by_sql(%Q{
            SELECT songs.*, song_playlist_relationships.playlist_id
            FROM songs INNER JOIN song_playlist_relationships
              ON songs.id = song_playlist_relationships.song_id
              WHERE song_playlist_relationships.playlist_id IN
(#{@playlists.collect{|p| p.id}.join(',')})})


Thank you,
Gleb
-- 
Posted via http://www.ruby-forum.com/.