Ver originalSELECT T1.fruta,Sum(T1.cantidad) AS totalFROM T1GROUP BY T1.fruta;
Ver originalSELECT T2.fruta,IFNULL(Sum(T1.cantidad),0) AS totalFROM T2 LEFT JOIN T1ON T2.fruta=T1.frutaGROUP BY T1.fruta;