title: How to set default value in SubQuery result using mysql
body: <p>How to set <strong>default</strong> VALUE in SubQuery result using mysql</p>
  
  <pre><code>SELECT      
      p.`id`, p.`name`, p.`class_name`, cpd.`status_team`,
      cpd.`home`, cpd.`guest`, cpd.`mvp`, cpd.`oscar`,
      cpd.`wam`, cpd.`status`, cpd.`added_date`,
      (SELECT result FROM result_cards WHERE `id` = cpd.`result`) AS DEFAULT(`result`)
  FROM `cron_players_data` cpd
  INNER JOIN `players` p ON cpd.`player_id` = p.id
  WHERE cpd.`added_date` = '2012-03-29' AND cpd.team_id = '15'
  </code></pre>
  
  <p>when i remove this <strong>DEFAULT()</strong> the Query will execute normally. Actually i want by default <strong>result</strong> value is 0 or helps are definitely appreciated </p>
  
  <p><img src="https://i.stack.imgur.com/aEyAv.jpg" alt="enter image description here"></p>