Código SQL:
Ver originalSELECT campoid,SUM(tipo) AS tipoo FROM plantas
LEFT JOIN usuarios.idu,usuarios.nombre ON plantas.campoid=usuarios.idu
GROUP BY campoid ORDER BY tipoo DESC LIMIT 20
me dice
errroYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'usuarios.nombre ON plantas.campoid=usuarios.idu group by campoid order by tipo' at line 2