title: Mysql SUM query is not showing all other column
body: <p>Hello I'm Trying to Sum the price of the selected topping and show all the names of selected topping, is it possible to do so ?</p>
  <p>here is the query</p>
  <pre><code>SELECT tord.Kode_topping_order, 
         t.Nama_topping, 
         SUM(t.Harga_topping) AS 'Total Topping' 
  FROM topping_order tord 
  JOIN topping t ON tord.Kode_Topping = t.Kode_topping 
  WHERE tord.Kode_Produk_Order = 39 
  </code></pre>
  <p>the output :</p>
  <p><a href="https://i.stack.imgur.com/nLO4N.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nLO4N.png" alt="Query" /></a></p>
  <p>However if I Group by Nama_topping the output will be like this:</p>
  <p><a href="https://i.stack.imgur.com/McCI7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/McCI7.png" alt="Query2" /></a></p>
  <p>Is it possible to have All of the Name of topping and all the Total Topping is filled with 12000 ?</p>