jh12345 Posted January 15, 2008 Share Posted January 15, 2008 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? Quote Link to comment https://forums.phpfreaks.com/topic/86109-help-with-mysql-query/ Share on other sites More sharing options...
fenway Posted January 15, 2008 Share Posted January 15, 2008 But if you limit by MONTH(), you won't get the other months automatically! Quote Link to comment https://forums.phpfreaks.com/topic/86109-help-with-mysql-query/#findComment-439828 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.