title: How to insert values into a table from two tables?
body: <ul>
  <li>Using MS office 2019</li>
  <li>I have a specific number of members in an association, each member is included in a specific category. I want to make a table that counts the present and absent members and the total number of the association in each category. –</li>
  <li>tblPerson (idPerson , idCategory)</li>
  <li>tblAbsent (idPerson , idSituation )</li>
  </ul>
  
  <pre><code>tblPerson
  -----------------------
  idPerson | idCategory |
  ----------------------+
  01       |   03       |
  02       |   02       |
  03       |   03       |
  04       |   01       |
  05       |   01       |
  06       |   01       |
  ---------+------------+
  
  tblAbsent
  ----------------------+
  idPerson | idSituation|
  ----------------------+
  01       |   02       |
  04       |   01       |
  05       |   04       |
  06       |   01       |
  ---------+------------+
  </code></pre>
  
  <p>I want to create 3rd table</p>
  
  <ul>
  <li>tblTotal (idCategory , tblPerson.COUNT(idCategory) AS total , tblAbsent.COUNT(idCategory) AS absent ,total-absent AS present  )</li>
  </ul>
  
  <pre><code>tblTotal
  -------------------+--------+---------+
  idCategory | total | absent | present |
  -----------+-------+--------+---------+
  01         |  03   |   03   |   00    |
  02         |  01   |   00   |   01    |
  03         |  02   |   01   |   01    |
  -----------+-------+--------+---------+
  </code></pre>