title: SQL Join two tables with a third table
body: <p>I want to create a query that selects the columns <code>PlayerName , PlayerNumber, Location, PartnerName, PartnerNumber, Location</code> from the following tables:</p>
  <ul>
  <li><code>Players</code> (Columns: Id, PlayerName, PlayerNumber, LocationId)</li>
  <li><code>Partners</code> (Columns: Id, PartnerName, PartnerNumber, LocationId)</li>
  <li><code>Locations</code> (Columns: Id, Location)</li>
  </ul>
  <p>But I cannot figure out how to do that. Does anyone have any ideas?</p>