title: Select Distinct returning multiple rows
body: <p>I've got a query that is:</p>
  
  <pre><code>SELECT DISTINCT a.field1, a.field2, a.field3, b.field1, b.field2, a.field4 
  FROM table1 a
  JOIN table2 b ON b.fielda = a.fieldb 
  WHERE a.field1 = 'xxxx'
  </code></pre>
  
  <p>I run this and it returns three xxxx rows.  I need all of the information listed above with the first field being distinct.  Do I have the correct syntax for this?</p>