title: What Microsoft SQL join to use
body: <p>I don't have a clue as to how to proceed with this as I am new to SQL. I have a two giant tables each with about 70,000 rows with the data of following type:</p>
  
  <p>Table 1:</p>
  
  <pre><code>A S D1
  A S D2
  A S D3
  B S C
  B S E1
  B S E2
  </code></pre>
  
  <p>Table 2:</p>
  
  <pre><code>A S D1
  B S E2
  </code></pre>
  
  <p>I want to get the following:</p>
  
  <pre><code>A S D1
  B S C
  B S E2
  </code></pre>
  
  <p>Edit:
  I need to have all data which is intersection of Tables 1 and 2. I also need to discard from Table 1, data which matches across columns 1 and 2 but not on column 3.</p>