subject:"\[SQL\] Advice on re\-writing a SELECT query."

Re: [SQL] Advice on re-writing a SELECT query.

2013-05-25 Thread Marc Mamin

I have a query like this: > >SELECT >lpt_titulo AS tmt_titulo, >tmd_nombre AS tmt_nombre, >tmd_album AS tmt_album >SUM(lpt_puntos) AS tmt_puntos, >lpt_fuente AS tmt_fuente >FROM listas_pre_titulos, temp_lista_titulos >WHERE >listas_pre_titulos.lpt_tipo = 3 AND >listas_pre_titulos.lpt_titulo <> temp

[SQL] Advice on re-writing a SELECT query.

2013-05-25 Thread JORGE MALDONADO

I have a query like this: SELECT lpt_titulo AS tmt_titulo, tmd_nombre AS tmt_nombre, tmd_album AS tmt_album SUM(lpt_puntos) AS tmt_puntos, lpt_fuente AS tmt_fuente FROM listas_pre_titulos, temp_lista_titulos WHERE listas_pre_titulos.lpt_tipo = 3 AND listas_pre_titulos.lpt_titulo <> temp_lista_titu