帮忙改一条mysql语句
SELECT a.LINKMAN_ID,b.CUSTOMER_ID,LINKMAN_NAME,SEX,a.TEL_NO_WORK,a.MOBILE,a.EMAIL as EMAIL,a.OICQ,a.ICQ,b.CUSTOMER_NAME,c.CONTACT_DATE,c.SELLER FROM `LINKMAN` a LEFT OUTER JOIN CUSTOMER b ON a.`CUSTOMER_ID` = b.`CUSTOMER_ID` LEFT OUTER JOIN CONTACT c on c.`CUSTOMER_ID`=b.`CUSTOMER_ID` where 1=1 ORDER BY a.CUSTOMER_ID desc LIMIT 0 ,10
CONTACT表中有一个字段[contact_date]为时间类型.结构如下:
contact_id customer_id contact_seller contact_date
1 122 张 2008-8-20
2 153 李 2008-8-21
3 122 张 2008-8-25
4 239 王 2008-8-26
我想查询最近时间联系的一条记录,请帮忙改一下上面的语句