title: DISTINCT columns from 2 different tables
body: <p>I have 2 tables with similar information. Let's call them <code>DAILYROWDATA</code> and <code>SUMMARYDATA</code>.</p>
  
  <p>Table <code>DAILYROWDATA</code></p>
  
  <pre><code>NIP  NAME   DEPARTMENT
  A1   ARIA   BB
  A2   CHLOE  BB
  A3   RYAN   BB
  A4   STEVE  BB
  </code></pre>
  
  <p>Table <code>SUMMARYDATA</code></p>
  
  <pre><code>NIP  NAME   DEPARTMENT  STATUSIN                STATUSOUT
  A1   ARIA   BB          1/21/2020  8:06:23 AM   1/21/2020  8:07:53 AM
  A2   CHLOE  BB          1/21/2020  8:16:07 AM   1/21/2020  9:51:21 AM
  A1   ARIA   BB          1/22/2020  9:06:23 AM   1/22/2020  10:07:53 AM
  A2   CHLOE  BB          1/22/2020  9:16:07 AM   1/22/2020  10:51:21 AM
  A3   RYAN   BB          1/22/2020  8:15:03 AM   1/22/2020  9:12:03 AM
  </code></pre>
  
  <p>And I need to combine these two tables and show all data in table <code>DAILYROWDATA</code> and set the value if <code>STATUSIN</code> = NULL and <code>STATUSOUT</code>= Null then write 'NA'. This is the output that I meant:</p>
  
  <pre><code>NIP  NAME   DEPARTMENT  STATUSIN                STATUSOUT
  A1   ARIA   BB          1/21/2020  8:06:23 AM   1/21/2020  8:07:53 AM
  A2   CHLOE  BB          1/21/2020  8:16:07 AM   1/21/2020  9:51:21 AM
  A3   RYAN   BB          NA                      NA
  A4   STEVE  BB          NA                      NA
  A1   ARIA   BB          1/22/2020  9:06:23 AM   1/22/2020  10:07:53 AM
  A2   CHLOE  BB          1/22/2020  9:16:07 AM   1/22/2020  10:51:21 AM
  A3   RYAN   BB          1/22/2020  8:15:03 AM   1/22/2020  9:12:03 AM
  A4   STEVE  BB          NA                      NA
  </code></pre>
  
  <p>I need to add some condition, so, i wanna set the value <code>STATUSIN = NULL</code> just when there is no <code>NIP,NAME,DEPARTMENT,STATUSIN,STATUSOUT</code> in one date.. so, that's can be multiple</p>