JOIN a table for 2 fields
<p>I have 2 tables, which I need to gather information from for 2 fields</p>

<pre><code>Table A
- ID
- WorkerResponsible
- WorkerTaker

Table B
- Id
- Name
- PersonnelNumber
</code></pre>

<p>I want to display the PersonnelNumber (MV) instead of the ID, but I am also not sure how to JOIN because of the 2 field, I have tried the following select code, but I am not sure if I have to join 2 times.</p>

<p>How can I gather the right information for both fields?</p>

<pre><code>SELECT
TableA.WorkerResponsible AS WorkerResponsible,
TableA.WorkerTaker AS WorkerTaker,
TableB.PersonnelNumber AS WorkerSalesResponsibleCode,
TableB.PersonnelNumber AS WorkerSalesTakerCode

FROM TableA
JOIN TableB ON TableB.Id = TableA.WorkerSalesResponsible AND TableB.Id = TableA.WorkerSalesTaker
</code></pre>