On Jul 28, 10:34 am, cocozz <[email protected]> wrote: > class Shopcategory0 < ActiveRecord::Base > set_table_name "shopcategories_0" > > has_many :shopcategory1s, :foreign_key => :parentcategory_id > end > > class Shopcategory1 < ActiveRecord::Base > set_table_name "shopcategories_1" > > belongs_to :shopcategory0, :foreign_key => :shopcategory_id > end > > class Shopcategory0sController < ApplicationController > def show > @shopcategory = Shopcategory0.all (:joins > => :shopcategory1s) > end > end > > --------------------- > That's the SQL result: > --------------------- > > Shopcategory0 Load (0.1ms) SELECT `shopcategories_0`.* FROM > `shopcategories_0` INNER JOIN `shopcategories_1` ON > shopcategories_1.parentcategory_id = shopcategories_0.id > > --------------------- > And this is what I search (notice the end): > --------------------- > > Shopcategory0 Load (0.1ms) SELECT `shopcategories_0`.* FROM > `shopcategories_0` INNER JOIN `shopcategories_1` ON > shopcategories_1.parentcategory_id = shopcategories_0.shopcategory_id > > I suppose there is a way to do that...I'll appreciate your help !!!
Is there a question in there? -e --~--~---------~--~----~------------~-------~--~----~ 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
