title: Inner join multiple ID columns with ID in foreign table to display multiple name columns
body: <p>I need to make a query that inner joins 3 different id's from one table with the id from another, to then display the name value from that table in my select query. I'll try to make it a bit more clear.</p>
  
  <p>In my one table I have these 3 columns with id's:</p>
  
  <pre><code>Book_Kalender.BS_ID,
  Book_Kalender.BS_ID_Prio2,
  Book_Kalender.BS_ID_Prio3,
  </code></pre>
  
  <p>These all need to be inner joined with a column in another table, which contains the name associated with these ids:</p>
  
  <pre><code>Book_Sommerhuse.[BS_ID]
  </code></pre>
  
  <p>In my SELECT query I am including the name column from the foreign table. I want to instead have 3 columns, each with the associated name that corresponds to the ID.</p>
  
  <pre><code>Book_Sommerhuse.BS_Navn
  </code></pre>
  
  <p>So far I have tried to make multiple inner joins using the AND keyword:</p>
  
  <pre><code>INNER JOIN Book_Kalender ON Book_Sommerhuse.[BS_ID] = Book_Kalender.[BS_ID] 
  AND Book_Sommerhuse.[BS_ID] = Book_Kalender.[BS_ID_Prio2]
  </code></pre>
  
  <p>But this returns and empty view from my select query. I'm also not sure how to create new columns for each name associated with the ID. </p>
  
  <p>Full query:</p>
  
  <pre><code>SELECT
      Book_Kalender.BK_ID,
      Book_Kalender.BK_DatoFra,
      Book_Kalender.BK_DatoTil,
      Book_Kalender.BK_M_Navn,
      Book_Kalender.BK_M_Adr,
      Book_Kalender.BK_M_PostBy,
      Book_Kalender.BK_M_Afd,
      Book_Kalender.BK_M_MedArbNr,
      Book_Kalender.BK_M_Tlf,
      Book_Kalender.BK_M_Email,
      Book_Kalender.BK_Tidl_Lejet,
      Book_Kalender.BK_Tidl_Lejet_Txt,
      Book_Kalender.BS_ID,
      Book_Kalender.BS_ID_Prio2,
      Book_Kalender.BS_ID_Prio3,    
      A.BS_Navn as BS_Navn1,
      B.BS_Navn as BS_Navn2,
      c.BS_Navn as BS_Navn3,
      coalesce(A.BS_Navn,B.BS_Navn,c.BS_Navn) as BS_Navn    
  FROM
      Book_Kalender
      LEFT JOIN Book_Sommerhuse A ON 
          Book_Kalender.BS_ID       = A.BS_ID
      LEFT JOIN Book_Sommerhuse B ON 
          Book_Kalender.BS_ID_Prio2 = B.BS_ID
      LEFT JOIN Book_Sommerhuse C ON 
          Book_Kalender.BS_ID_Prio3 = C.BS_ID    
  WHERE
      Book_Kalender.BK_DatoFra BETWEEN #10/15/2017# AND #12/31/2018#;
  </code></pre>