title: How to solve null value in MySQL?
body: <p>I want to show data separately from income and expense table in MySQL using same query for both things but it show me when show income title date then same show  expense title date. But I need to do if it find income table's 4th row and if find expense table's 2nd row, but it show me 4th row. Why?</p>
  
  <pre><code>SELECT  income.date, 
          IF(income.income_sourch IS NULL, 'N/A', income.income_sourch )as 'Income Title',
          income.amount as 'income',
          IF(expense.expense_sourche IS NULL, 'N/A', expense.expense_sourche)  as 'ExpenseTitle',
          expense.amount as 'Expense'
  from expense  RIGHT JOIN income
       ON expense.date=income.date
  where expense.date='30-Aug-2016'
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/U99Zn.png" alt="enter image description here"></p>