title: No duplicates in SQL query
body: <p>I'm doing a select in MySQL with an inner join:</p>
  
  <pre><code>SELECT DISTINCT tblcaritem.caritemid, tblcar.icarid 
  FROM tblcaritem 
  INNER JOIN tblprivatecar ON tblcaritem.partid = tblprivatecar.partid 
  INNER JOIN tblcar ON tblcaritem.carid = tblcar.carid 
  WHERE tblcaritem.userid=72;
  </code></pre>
  
  <p>Sometimes I get duplicates of tblcaritem.caritemid in the result. I want to make sure to never get duplicates of tblcaritem.caritemid, but how can I do that? I tried to use DISTINCT but it just checked if the whole row is a duplicate, I want to check for only tblcaritem.caritemid, is there a way?</p>
  
  <p>Sorry if I didn't explain it very well, I'm not the best of SQL queries.</p>