title: SQL SELECT statement when using look up table
body: <p>sorry if I'm not framing this question properly but I'm very new to <code>SQL</code> statements and I can't seem to get this right I need help working out how to do a <code>SELECT</code> statement with a <strong>lookup</strong> table involved, there's the situation: </p>
  
  <pre><code>Employee table
  [ID], [Name], [StartDate]
  
  User_Roles (lookup) table
  [Employee_ID], [Role_ID]
  
  Roles Table
  [Id], [RoleName]
  </code></pre>
  
  <p>So, from what I can see the <code>employee</code> has an <strong>ID, Name, and StartDate,</strong> </p>
  
  <p>the <code>User_Roles</code> table assigns a <strong>role ID to the user ID</strong> and </p>
  
  <p>the <code>Roles Table</code> has the <strong>Roles Codes</strong>. </p>
  
  <p>I needed a <strong>Select statement</strong> that returns: </p>
  
  <pre><code>Employee.ID, Employee.Name, Employee.StartDate, Roles.RoleName
  </code></pre>
  
  <p>Based on what the mapping is in the <code>User_Roles</code> table. </p>
  
  <p>Many thanks in advance for your help</p>