title: How to bring NULL value even after Join is present in MYSQL LEFT JOIN
body: <p>I have 2 tables named as DEPARTMENT_MASTER AND DIVISION_MASTER in MySQL Database.</p>
  
  <pre><code>DEPARTMENT_MASTER              DIVISION_MASTER
  DEPT_ID | DEPT_NAME            DIVISION_ID | DIVISION_NAME | DEPT_ID
  1       | HR                   1           | DIV1          | 1
  2       | CLINICAL             2           | DIV2          | 1
  3       | IT                   3           | DIV3          | 2
  </code></pre>
  
  <p>I have this simple SQL query as -</p>
  
  <pre><code>SELECT DM.DEPT_NAME, DV.DIVISION_NAME, DM.DEPT_ID, DV.DIVISION_ID 
  FROM DEPARTMENT_MASTER DM 
  LEFT JOIN DIVISION_MASTER DV ON DM.DEPT_ID = DV.DEPT_ID
  </code></pre>
  
  <p>So for that i get result like this</p>
  
  <pre><code>DEPT_NAME | DIVISION_NAME | DEPT_ID | DIVISION_ID
  HR        | DIV1          | 1       | 1
  HR        | DIV2          | 1       | 2
  CLINICAL  | DIV3          | 2       | 3
  IT        | NULL          | 3       | NULL
  </code></pre>
  
  <p>Is there any way so that i can get result like this-</p>
  
  <pre><code>DEPT_NAME | DIVISION_NAME | DEPT_ID | DIVISION_ID
  HR        | NULL          | 1       | NULL
  HR        | DIV1          | 1       | 1
  HR        | DIV2          | 1       | 2
  CLINICAL  | NULL          | 2       | NULL
  CLINICAL  | DIV3          | 2       | 3
  IT        | NULL          | 3       | NULL
  </code></pre>