CRM进度跟踪中,客户需要查询出客户电话营销中最后一个客户联系人和访谈记录,由于他们需要的不止一个字段(不然我可以通过top 1 field来解决),所以需要多个表的关联
select A. * ,B. * from CRM_TALK_MAIN A left join ( select * from CRM_CUSATTN c,( select m.cus_no, MAX (MODIFY_DT) as times from CRM_TALK_MAIN m left join CRM_CUSATTN n on n.cus_id = m.cus_no group by m.cus_no) x where exists ( select 1 where x.cus_no = c.cus_id and x.times = c.MODIFY_DT) ) B on B.cus_no = A.cus_no 其中CRM_TALK_MAIN是主表,CRM_CUSATTN是访谈表.
