I have a working SQL query I'm trying to convert to Arel. I'm trying to work out the syntax for a self referential join on a table.
I can't work out how to address the table as 's1' and 's2' so my query makes sense. irb(main):018:0> s1.join(s2).on(s1[:serviceid].eq(s2[:serviceid]), s1[:id].gt(s2[:id])).where(s2[:serviceid].eq(nil)).to_sql => "SELECT FROM `service` INNER JOIN `service` ON `service`.`serviceid` = `service`.`serviceid` AND `service`.`id` > `service`.`id` WHERE `service`.`serviceid` IS NULL" Has anyone done this? - Mike -- You received this message because you are subscribed to the Google Groups "Ruby or Rails Oceania" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rails-oceania?hl=en.
