jh12345 Posted January 15, 2008 Share Posted January 15, 2008 I have a table setup like this: name | email | date Joe [email protected] 2005-05-18 21:58:43 Jane [email protected] 2005-06-18 20:50:41 John [email protected] 2005-06-18 23:48:33 Joe [email protected] 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? 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! Link to comment https://forums.phpfreaks.com/topic/86109-help-with-mysql-query/#findComment-439828 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.