title: mysql select unique records
body: <p>I've got the following query:</p>
  
  <pre><code>select * from members,subscriptions
  where members.MemberID = subscriptions.MemberID
  and subscriptions.Year = 2009
  and members.ASSCID = 15
  and subscriptions.Untildate between '$2009-01-01' and '2009-12-31'
  order by members.Memberlastname
  </code></pre>
  
  <p>Members pay either their annual subscription once (annual subscription) or they pay 2 times, one in january and one in june (six month subscriptions). What i want is to pull the members who paid at least once.</p>
  
  <p>The statement above will bring some members twice (those who paid both on january and june).</p>
  
  <p>Is is possible to pull the members who paid at least once (no matter if they paid an annual or a six month subscription). Avoiding duplicates.</p>