is this a right query to get the info I need
    SELECT
    
    table1.id
    
    From 
    table1
    Join 
    table2
    ON 
    table1.id = table2.id 
    
    WHERE 
    table1.`date` BETWEEN CURDATE() - INTERVAL 1 MONTH AND CURDATE();


join table record set is 

    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

I was wondering if this is the right where clause to find if the customer that has a date over 30 days due.

is this a right query to get the info I need
===

    SELECT
    
    table1.id
    
    From 
    table1
    Join 
    table2
    ON 
    table1.id = table2.id 
    
    WHERE 
    table1.`date` BETWEEN CURDATE() - INTERVAL 1 MONTH AND CURDATE();


join table record set is 

    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

I was wondering if this is the right where clause to find if the customer that has a date over 30 days due.
