title: Join Only Unique Values From 2 Tables
body: <p>I'm trying to join two MySQL tables, and return only the unique values between them. eg.</p>
  <pre><code>Table1
  column1|column2
  -------------
  c1value1|c2value1-1
  c1value2|c2value1-2
  c1value3|c2value1-3
  </code></pre>
  <pre><code>Table2
  column1|column2
  -------------
  c1value1|c2value1-1
  c1value1|c2value2-1
  c1value1|c2value3-1
  c1value2|c2value1-2
  c1value3|c2value1-3
  </code></pre>
  <p>I want to get as my result a table that <em>only</em> shows the intersections of rows without any duplicates where I'm joining on table1.column1 = table2.column1:</p>
  <pre><code>Joined Table
  table1.column2|table2.column2
  -----------------------------
  table1.c2value1-2|c2value1-2
  table1.c2value1-3|c2value1-3
  </code></pre>
  <p>Simple joins and unions and I'm ok, but this one is causing me a headache.</p>
  <p>Edit for clarification:
  I don't want any results in my joined table where Table 2 has &gt; 1 entry in column 1. I only want to get back the values from column2 for c1value2 and c1value3.</p>
  <p>My first thought was to get the distinct count of column2 GROUP BY column1 WHERE distinct count = 1 but that's error city.</p>