title: Join over multiple tables
body: <p>I want to query the Database (SQL Server 2019 Ent.) of an existing 3rd party application. We have <code>assets</code>, their <code>properties</code>, and further tables like <code>managers</code>, locations,...
  The properties are listed in a dedicated table and can contain the value as text or a further <code>ID</code> eg. to lookup a managers details. In some cases there are many hundreds of properties per asset. If a property is not set, there is no such record in table <code>assets</code></p>
  <p>As an example find a demo-setup here:</p>
  <p><a href="https://dbfiddle.uk/?rdbms=sqlserver_2016&amp;fiddle=91ebe7c2387fff056c44e927d0e31d54" rel="nofollow noreferrer">https://dbfiddle.uk/?rdbms=sqlserver_2016&amp;fiddle=91ebe7c2387fff056c44e927d0e31d54</a></p>
  <p>The goal ist to list each asset inlcluding some specific properties in one record.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>asset</th>
  <th>manager</th>
  <th>stby_manager</th>
  <th>stage</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>saturn-n1</td>
  <td>Carl</td>
  <td>David</td>
  <td>Production</td>
  </tr>
  <tr>
  <td>saturn-n2</td>
  <td>David</td>
  <td></td>
  <td>Production</td>
  </tr>
  <tr>
  <td>mars-n1</td>
  <td>Tim</td>
  <td>David</td>
  <td></td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>My first idea was to create a temp-table containig the asset and its properties, including the IDs, and then to join the temp-table against the corresponding key tables in a second step. But I'm wodering if there is an easyer way, by joinig the properties and key tables in a whole query?
  And btw.; is there a name for this kind of database queries problem? That would have helped me to goolge for it.</p>