title: INNER join Return Not Returning total Results
body: <p>trade_data Table</p>
  
  <hr>
  
  <p>id symbol action price percent</p>
  
  <hr>
  
  <p>1    1      Buy   3.4    50</p>
  
  <hr>
  
  <p>2    1      SELL   3.8   25</p>
  
  <hr>
  
  <p>3    2      sell   45    75</p>
  
  <hr>
  
  <p>3    2      buy    25.2  50</p>
  
  <hr>
  
  <p>symbol Table</p>
  
  <hr>
  
  <p>id  name</p>
  
  <hr>
  
  <p>1   RCC</p>
  
  <hr>
  
  <p>2   REG</p>
  
  <hr>
  
  <hr>
  
  <p>SELECT SUM( IF( trade_data.action =  'BUY', price, 0 ) ) AS  'BUYSUM', SUM( IF( trade_data.action =  'SELL', price, 0 ) ) AS  'BUYSELL', AVG( trade_data.percent ) AS peravg, symbol. * 
      FROM  <code>trade_data</code> 
      INNER JOIN  <code>symbol</code> ON trade_data.symbol = symbol.id</p>
  
  <p>This Query Gives me One Row But there Are Two Row are available at this Condition.
  But When I change the query As</p>
  
  <pre><code>SELECT trade_data.* , symbol. * 
  FROM  `trade_data` 
  INNER JOIN  `symbol` ON trade_data.symbol = symbol.id
  </code></pre>
  
  <p>Then this Query Gives me Exact 2 Rows.</p>