title: How to do a LEFT JOIN in MS Access without duplicates?
body: <p>I have 2 tables with duplicated values in one of the columns. I'd like to do a left join without taking rows, where mentioned column values duplicates.
  For example,
  i have table X:</p>
  
  <pre><code>id  Value
  A   2
  B   4
  C   5
  </code></pre>
  
  <p>and table Y:</p>
  
  <pre><code>id   Value
  A  2
  A  8
  B  2
  </code></pre>
  
  <p>I'm doing a LEFT JOIN:</p>
  
  <pre><code>SELECT*
  FROM X LEFT JOIN Y ON X.id = Y.id;
  </code></pre>
  
  <p>Would like to have something like:</p>
  
  <pre><code>id   Value
  A   2   A   2
  B   4   B   2
  C   5
  </code></pre>
  
  <p>so that duplicated id (A   8) from table Y is not considered.</p>