<% @g2_items = G2Item.find_by_sql("SELECT g.g_title, g.g_id FROM g2_Item g, g2_AlbumItem a WHERE g.g_id = a.g_id") %> <%= select("Thing", "g_id", @g2_items.collect {|p| [ p.g_title, p.g_id ] }, { :include_blank => false }) %>