> Dear friends, > > I am developing a database application for our saleses > with PHP and MySQL. > Our sales must call the customers on time. They may > not be late to call the customers. The may not miss > the appointment to meet the customer on the telephone > line. > But I have a problem to implement the SQL query on > MySQL DB Engine. > > Suppose I have this simple table ("APPOINTMENT" Table) > : > > CUSTID Cont_Pers APPOINTMENT_TIME > 1 Albert 2002-10-23 13:00:00 > 2 Sarah 2002-10-24 14:00:00 > 3 Sandra 2002-10-23 08:00:00 > ... ... ... > ... ... ... > > I want to display one record which contain the > appointment which has closest time between the current > time ( "sysdate()" ) and the APPOINTMENT_TIME. > > So each the sales query one record (select) the record > from this table with application than they will finf > the record which has the earliest appointment time. > > I tried this SQL Query but it doesn't work : > " > SELECT * > FROM Appointment > WHERE MIN(sysdate()-appointment_time) > GROUP BY CustID > " > > Please tell me to determine the proper SQL Statement. > > Thank you very much in advance. > > __________________________________________________
--------------------------------------------------------------------- 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