title: Select DISTINCT values with where clause returning more than one result on inner join
body: <p>Code is as follows:</p>
  
  <pre><code>SELECT DISTINCT * 
  FROM tblWCS_Bulletins 
  INNER JOIN tblWCS_BulletinComments ON tblWCS_BulletinComments.BulletinID = tblWCS_Bulletins.RowID 
  WHERE VisibleTo LIKE ('%@' + @UserID + '@%') 
    AND CommentString LIKE ('%'   + @SearchString + '%')
     OR VisibleTo LIKE ('%@' + @UserID + '@%') 
    AND BulletinHeader LIKE ('%' +   @SearchString + '%') 
     OR VisibleTo LIKE ('%@' + @UserID + '@%') 
    AND BulletinContent LIKE ('%' + @SearchString + '%'
  </code></pre>
  
  <p>But this returns duplicates of the rows from the first table if more than one result is found in the second table. I want the result to only return one row from the first table, even if there is more than one row in the second joined table found.</p>