title: is this a right query to get the info I need
body: <pre><code>SELECT
  
  table1.id
  
  From 
  table1
  Join 
  table2
  ON 
  table1.id = table2.id 
  
  WHERE 
  table1.`date` BETWEEN CURDATE() - INTERVAL 1 MONTH AND CURDATE();
  </code></pre>
  
  <p>join table record set is </p>
  
  <pre><code>id  customer    date
  1   john        2011-01-01
  2   john1       2011-02-02
  3   john2       2011-03-03
  4   john3       2011-04-04
  5   john4       2011-05-05
  6   john5       2011-06-06
  7   john6       2011-07-07
  8   john7       2011-08-08
  9   john8       2011-09-09
  10  john9       2011-10-10
  11  john10      2011-10-11
  </code></pre>
  
  <p>I was wondering if this is the right where clause to find if the customer that has a date over 30 days due.</p>