title: Inserting a Zero instead of NULL while performing LEFT OUTER JOIN in MYSQL
body: <p>Is there a way to insert a zero instead of NULL while performing LEFT OUTER JOIN on two tables? </p>
  
  <p>Suppose I have a query like this:</p>
  
  <pre><code>SELECT * FROM
  (SELECT uID from Class) T1
  LEFT OUTER JOIN
  (SELECT pID from University) T2
  ON T1.uID = T2.pID
  CASE WHEN T1.uID IS NULL
      THEN 0
  ELSE T1.uID
  END AS uID`
  </code></pre>
  
  <p>Correct me if I'm wrong</p>