Problemi con query funzione Join Left

[chris]

SELECT x.ID,AVG( y.Points ) , z.Pollo, z.Zucchine
FROM x
LEFT JOIN y ON
x.ID = y.ID LEFT JOIN z ON x.ID = z.ID
WHERE x.CASA = 'Rome'
AND x.Pane= 'Casareccio'
GROUP BY x.ID