34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT top 10 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
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 and not exists (select 1 from CONTACT where CUSTOMER_ID=c.CUSTOMER_ID and CONTACT_DATE>c.CONTACT_DATE)
ORDER BY a.CUSTOMER_ID desc LIMIT 0 ,10