Hi All! This is my first question to the list. Can some one help out a newbie with a simple question please? The closest thing I found is a php query to do this using temporary tables but it takes too long.
Table 1 Name Date John 01/10 Jack 01/10 Jill 01/10 Mary 02/10 John 02/10 Jill 02/10 John 03/10 Jill 03/10 Mac 04/10 Alex 04/10 Jill 04/10 I want to select everyone with date > 03/10 but not date < 02/10. (Should be Mac and Alex) Also I want to select everyone with date < 03/10 but not date > 03/10. (Should be Mary and Jack) Thanks for your replies Regards, Ershad --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
