Kriege SQL Abfrage nicht hin

[DiBo33]

  
SELECT t1.product_name, t1.product_volume, t1.ID  
FROM t_produkte  AS t1  
WHERE t1.product_volume = (  
  SELECT MAX(product_volume)  
  FROM t_producte  
  WHERE product_name = t1.product_name  
)