Agrupar y Grabar

[bandolera]

Iniciado por Libras

Claro que si, seria algo como esto:

Código MySQL:

update saldos
set cantidad=t1.total
from(
SELECT codigo, COUNT(codigo) as total
FROM movi 
GROUP BY codigo 
HAVING COUNT(codigo)>0  ) as t1 where saldos.codigo=t1.codigo
 

Me sale este error:

Código HTML:

 #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from( SELECT codigo, COUNT(codigo) as total FROM movi GROUP BY codigo HAVI' at line 3