select
//FROM_UNIXTIME(字段名,‘%Y年%m月%d’)把时间戳转换成时间
D.service_type_desc,D.abstract,D.user_name,D.department,FROM_UNIXTIME(D.create_time,'%Y年%m月%d')
FROM(
//这里为三表查询,通过中间表B与A,C表相连
select a.service_type_desc, a.abstract, a.create_time, b.user_name, b.`depart_id`, c.`department`
FROM `cor_crm_action` a JOIN `cor_admin_user` b on a.`saler_id`= b.`user_id` JOIN `cor_crm_depart` c ON b.`depart_id`= c.`id`) D
WHERE D.create_time>1638288000 and `user_name` NOT IN('张大大')
cor_crm_action //为a表
cor_admin_user //为b表
cor_crm_depart //为c表
a与b表连接是有公用的字段a表(销售表)的saler_id(销售员id)等于b表(员工表)的user_id(用户id)
b与c表链接是有公用的字段b表(员工表)的depart_id(部门id)等于c表(部门表)的id(部门id)
a.service_type_desc //a表的字段名
a.abstract //a表的字段名
a.create_time //a表的字段名
b.user_name //b表的字段名
b.depart_id //b表的字段名
c.department //c表的字段名