title: Results based on two related criteria posgresql
body: <p>can sql search by two related criteria? If so, I would like to ask how to do it. I have two criteria, it is the personal code and the date of the personal code:</p>
  <pre><code>| Personal_id |    Date     |
  
  | 12345       |  1/25/2022  |
  | 1478963     |  5/13/2022  |
  | 147895555   |  10/25/2022 |
  | 98765432    |  1/25/2022  |
  </code></pre>
  <p>the table shows the personal codes and their signing dates. I need to find out the ID of the signed document, what it was when that particular customer signed with that personal code and that particular date.</p>
  <p>There are about 100 options like this, so I want to know if it is possible to find that document id based on two criteria related to the personal code and date.</p>
  <p>I don't need a complete request, I just need some function or logic to do it</p>