title: MS Access 2007 JOIN on Multiple Fields
body: <p>I have a two tables similar to the following:</p>
  
  <p><img src="https://i.stack.imgur.com/ghWdS.gif" alt="enter image description here"></p>
  
  <p><img src="https://i.stack.imgur.com/s68Wp.gif" alt="enter image description here"></p>
  
  <p>I am attempting to create a query in Access to create a table like this:</p>
  
  <p><img src="https://i.stack.imgur.com/zq1Qx.gif" alt="enter image description here"></p>
  
  <p>The crux of course is that the JOIN must match against both the Date and Name fields. I can join the fields from T2 into T1.</p>
  
  <p>What is the proper syntax (either in SQL or via the query designer) to join the fields on both Date and Name?</p>
  
  <p>My attempts have duplicated the field count.</p>