title: SQL select with join are returning double results
body: <p>I am trying to select some data from different tables using join.</p>
  
  <p>First, here is my SQL (MS) query:</p>
  
  <pre><code>SELECT Polls.pollID, 
         Members.membername, 
         Polls.polltitle, (SELECT COUNT(*) FROM PollChoices WHERE pollID=Polls.pollID) AS 'choices',
         (SELECT COUNT(*) FROM PollVotes WHERE PollVotes.pollChoiceID = PollChoices.pollChoicesID) AS 'votes'
  FROM Polls
  INNER JOIN Members
  ON Polls.memberID = Members.memberID
  INNER JOIN PollChoices
  ON PollChoices.pollID = Polls.pollID;
  </code></pre>
  
  <p>And the tables involved in this query is here:
  <img src="https://i.stack.imgur.com/3QA9V.png" alt="tables"></p>
  
  <p>The query returns this result:</p>
  
  <pre><code>pollID   | membername | polltitle | choices | votes
  ---------+------------+-----------+---------+-------
  10000036 | TestName   | Test Title|   2     |   0
  10000036 | TestName   | Test Title|   2     |   1
  </code></pre>
  
  <p>Any help will be greatly appreciated.</p>