title: Total amount of columns in mySQL !
body: <p>i have this sql : </p>
  
  <pre><code>SELECT * , (
  xnum * xprice
  ) AS amount, SUM( xnum * xprice ) AS total
  FROM xxbasket
  LEFT JOIN xxsubproduct
  USING ( xsubproduct_id )
  LEFT JOIN xxcolor
  USING ( xcolor_id )
  WHERE xuserid = '3'
  </code></pre>
  
  <p>when i use SUM( xnum * xprice ) AS total it's gives me only one row , but when i remove this SUM( xnum * xprice ) it's give me all rows </p>
  
  <p>My question is how can i get sum ? while i need all rows from query ?! </p>