Help with MYSQL query

[jh12345]

I have a table setup like this:

 

name | email | date

Joe   joe@test.com   2005-05-18 21:58:43

Jane   jane@test.com   2005-06-18 20:50:41

John   John@test.com   2005-06-18 23:48:33

Joe   joe@test.com   2005-06-18 20:18:13

 

I need to query this table to give me the names and email addresses for a particular month excluding and names for that month that appear in previous months.

 

Using the above example data if I were to query for the month of June, the query would return two records (jane and John) excluding the record for Joe because he appears already in the table with a May entry.

 

The Table is called ORDERS

 

Many thanks in advance for any help you can assist me with?

[fenway]

But if you limit by MONTH(), you won't get the other months automatically!