Guest User

Untitled

a guest
Jul 17th, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. I need help with this statement: s=DatosMateria.sum('inscritos',:conditions=> "datos_materia.ano=2005 AND materias.codigo=2394",:include=>"materias"). it generates : SELECT sum('datos_materia'.inscritos) AS sum_inscritos FROM 'datos_materia' LEFT OUTER JOIN 'materias' ON materias.codigo=datos_materia.id WHERE.. I need it to join on materias.codigo=datos_materia.codigo_materia instead of materias_codigo=datos_materia.id How can I do that?
  2.  
  3. class DatosMateria < ActiveRecord::Base
  4. set_table_name "datos_materia"
  5.  
  6. has_many :materias,:foreign_key => "codigo"
  7. end
  8.  
  9. class Materia < ActiveRecord::Base
  10.  
  11. set_primary_key "codigo"
  12. belongs_to :datosMateria, :foreign_key=> "materia_codigo"
  13.  
  14. end
Add Comment
Please, Sign In to add comment