title: Update specific column with the value of single column from another table
body: <p>I want to update the specific column with value of a single column from another table using sql query.</p>
  
  <p>The specific column I want to update is in the <code>WorkingTime</code> table. Like for example I want to update its value by 1 depending on its <code>IDNo</code> and <code>Date</code> from TABLE 2</p>
  
  <p><code>WorkingTime</code> table:</p>
  
  <pre><code> IDNo   | PeriodDate | SPLP | NVLP | NBLP | PLP | BLP | MLP | SLP | VLP | NSLP |
  18-031  |06/11/2017  |  0   |  0   |  0   |  0  |  0  |  0  |  0  |  0  |  0   |
  18-032  |06/12/2017  |  0   |  0   |  0   |  0  |  0  |  0  |  0  |  0  |  0   |
  18-033  |06/13/2017  |  0   |  0   |  0   |  0  |  0  |  0  |  0  |  0  |  0   |
  </code></pre>
  
  <p>And the name of the column I want to update in <code>WorkingTime</code> is in the <code>LeaveDetails</code>. The column with the name <code>LeaveType</code>.</p>
  
  <p><code>LeaveDetails</code>:</p>
  
  <pre><code>Contro  | IDNo   | LeaveType| DateFrom | DateTo   | NoOfDays |
  000041  |18-031  |  SPLP    |06/11/2019|06/11/2019|  1       |
  000042  |18-032  |  NVLP    |06/12/2019|06/12/2019|  1       |
  000043  |18-033  |  PLP     |06/13/2019|06/13/2019|  1       |
  </code></pre>
  
  <p>And my expected result after the query is this</p>
  
  <p>Expected result:</p>
  
  <pre><code> IDNo   | PeriodDate | SPLP | NVLP | NBLP | PLP | BLP | MLP | SLP | VLP | NSLP |
  18-031  |06/11/2017  |  1   |  0   |  0   |  0  |  0  |  0  |  0  |  0  |  0   |
  18-032  |06/12/2017  |  0   |  1   |  0   |  0  |  0  |  0  |  0  |  0  |  0   |
  18-018  |06/13/2017  |  0   |  0   |  0   |  1  |  0  |  0  |  0  |  0  |  0   |
  </code></pre>
  
  <p>Can anyone please help me with the query i will use to make this happen. Thank you in advance.</p>