Welcome Guest, Not a member yet? Register   Sign In
JOIN whit active record, 3 tables + pagination..
#1

[eluser]tnathos[/eluser]
HI.. how i can make this query whit Active record.. and i need put tha pagination..


Code:
select a.titulo, b.marca, sum(c.puntos) as puntos
from
table1 a,
table2 b,
table3 c
where
a.marca=b.id and
a.id_proceso=c.id_proceso and
a.estado =1
group by
a.titulo, b.marca
order by puntos DESC
LIMIT 10, 5


Messages In This Thread
JOIN whit active record, 3 tables + pagination.. - by El Forum - 01-26-2010, 10:11 AM
JOIN whit active record, 3 tables + pagination.. - by El Forum - 01-26-2010, 01:05 PM
JOIN whit active record, 3 tables + pagination.. - by El Forum - 01-26-2010, 02:36 PM



Theme © iAndrew 2016 - Forum software by © MyBB