title: Hive - Adding 2 columns for each row with some null values
body: <p>I have an SQL query where I am joining 2 tables, on another table  - A and B
  Table A is being joined on table E on ID = ID 
  Table B is being joined on table E on ID = SKU</p>
  
  <p>Table A and Table B both have columns Price, Value </p>
  
  <p>Sometimes there are null values in here </p>
  
  <p>I have done Select ID, (A.Price + B.Price) AS TEST, (A.Value + B.Value) 
  AS TEST2 from E</p>
  
  <p>But I am getting NULL values for all of the results for test and test2</p>
  
  <p>Query is:</p>
  
  <pre><code>select PII, PII_Count, SK_Count, (PII_Count - SK_Count) as TEST from CIEER
  left join ccq on CIEER.PII = ccq.PRIE 
  left join ccrq on CIEER.PII = ccrq.SKIE
  order by PII_Count desc
  </code></pre>