title: MYSQL - Query to check against other table (hard to explain...)
body: <p>I have a query that gets a list of emails who have subscribed for a newsletter trial which lasts 30 days..<br></p>
  
  <pre><code>$thirty = time() - 3024000;
  
  SELECT c.email 
    FROM tbl_clients AS c 
    JOIN tbl_clientoptions AS o ON o.client = c.id 
   WHERE o.option = 'newsletter' 
     AND c.datecreated &gt; $thirty
  </code></pre>
  
  <p>What I want to do is do a check in that same query so it also returns clients OVER 30 days old if they have the tbl_clientoptions.option = 'trialoverride' (ie; a row in the client options table with the value "trialoverride")</p>
  
  <p><code>TBL_CLIENTS</code> table:</p>
  
  <ul>
  <li>id</li>
  <li>name</li>
  <li>email</li>
  <li>datecreated</li>
  </ul>
  
  <p><code>TBL_CLIENTOPTIONS</code> table:</p>
  
  <ul>
  <li>id</li>
  <li>client</li>
  <li>option</li>
  </ul>