title: OR WHERE and AND in mySQL Query
body: <p>Basically, I'm trying to get data from an SQL based on two different groups, <code>t.type</code> has to equal <code>single</code> and <code>t.status</code> has to equal <code>1</code> but as for <code>t.org</code> I want to it get both <code>DUAL</code> and <code>RA</code>, here's what I attempted to no avail.</p>
  
  <pre><code>SELECT 
      COUNT( p.tID ) 
  FROM 
      ticket AS t 
  INNER JOIN 
      people AS p ON t.ID = p.tID 
  WHERE 
      t.type = 'single' AND t.status='1' AND t.org = 'RA' OR t.org = 'DUAL'
  </code></pre>
  
  <p>I'm pretty sure theirs a way to get this query working, just not in my head</p>