表:沟通表有联系人的id做外键,联系人有客户id做外键 1,不用左连接了?? 2,什么情况下需要给两张表建关联表:当两张表的主键是多对多的关系时必须建一张中间关联表
--------------------
--queryCommunicateByCustomerIdselect * from crm_communicate
where deleteflag <> 'Y'
and crm_communicate.contact_id in(select contact_id from crm_contact where customer_id =:customerId)
order by communicate_time desc
limit 0,5;