56,687
社区成员
发帖
与我相关
我的任务
分享
select t.htId,t1.id,t2.id,t3.id ,htNo 合同编号,visitType 回访类型,success 回访状态,buy 客户姓名,buyPhone 客户电话,seller 房东姓名,sellerPhone 房东电话,storeDegree 门店评价,transferDegree 客户评价,warrantUserId 权证评价,processDate 过户日期,visitDate 回访日期,t2.`name` 录入人,t3.`name` 录入部门,flowuser 流程人,flowdept 流程部门,signuser 签约人,t1.signdept 门店,t1.dname 门店区域,houseAddress 位置,turnRefer 转介绍,t.createDate 录入日期,t.remark 备注,t4.dPhone 店长电话
from
ht_visit t LEFT JOIN (select t.id,t.htNo,t.buy,t.buyPhone,t.seller,t.sellerPhone,t.processDate,t.flowuser,t.flowdept,t.signuser,t.houseAddress,t.signdept,t1.`name` as dname FROM v_ht_info t LEFT JOIN
(select t.id,t.name,t2.p_id,t2.signdept FROM b_organs t,(select t1.id,t1.p_id,t.signdept,t1.name from v_ht_info t,b_organs t1 where t.signdept=t1.name) t2 where t.id=t2.p_id) t1 ON t.signdept=t1.`name`) t1
ON t.htId=t1.id
LEFT JOIN b_emp t2 ON t.userId =t2.id
LEFT JOIN b_organs t3 ON t.deptId =t3.id
LEFT JOIN (select t.name,t.phone as dPhone,t.name1,t.sysOrgan_id,t1.name as name2,t1.id from
(select t.name,t.phone,t1.name as name1,t.sysOrgan_id from b_emp t JOIN b_position t1 ON t.position_id = t1.id where t1.id=116 and t.status=243) t JOIN b_organs t1 ON t.sysOrgan_id = t1.id) t4 on t1.signdept =t4.name2
select t.deptId,t.userId,t.htId,t1.id,t2.id,t3.id,htNo 合同编号,visitType 回访类型,success 回访状态,buy 客户姓名,buyPhone 客户电话,seller 房东姓名,sellerPhone 房东电话,storeDegree 门店评价,transferDegree 客户评价,warrantUserId 权证评价,processDate 过户日期,visitDate 回访日期,t2.`name` 录入人,t3.`name` 录入部门,flowuser 流程人,flowdept 流程部门,signuser 签约人,t1.signdept 门店,t1.dname 门店区域,houseAddress 位置,turnRefer 转介绍,t.createDate 录入日期,t.remark 备注,t1.dPhone 店长电话
from
ht_visit t LEFT JOIN (select
t.id,t.htNo,t.buy,t.buyPhone,t.seller,t.sellerPhone,t.processDate,t.flowuser,t.flowdept,t.signuser,t
.houseAddress,t.signdept,t1.`name` as dname,t2.dPhone FROM v_ht_info t LEFT JOIN
(select t.signdept,t.p_id,t1.id,t1.`name` FROM (select t.signdept,t1.name,t1.id,t1.p_id from
v_ht_info t LEFT JOIN b_organs t1 ON t.signdept =t1.`name`) t LEFT JOIN b_organs t1 ON t.p_id=t1.id)
t1 ON t.signdept =t1.signdept
LEFT JOIN
(select t.name,t.phone as dPhone,t.name1,t.sysOrgan_id,t1.name as
name2,t1.id from
(select t.name,t.phone,t1.name as name1,t.sysOrgan_id from b_emp t JOIN b_position t1 ON
t.position_id = t1.id where t1.id=116 and t.status=243) t JOIN b_organs t1 ON t.sysOrgan_id = t1.id
GROUP BY t1.id ) t2 ON t.signdept =t2.name2 GROUP BY htNo) t1 ON t.htId = t1.id
LEFT JOIN b_emp t2 ON t.userId =t2.id
LEFT JOIN b_organs t3 ON t.deptId =t3.id
select t.htId,t1.id,t2.id,t3.id ,htNo 合同编号,visitType 回访类型,success 回访状态,buy 客户姓名,buyPhone 客户电话,seller 房东姓名,sellerPhone 房东电话,storeDegree 门店评价,transferDegree 客户评价,warrantUserId 权证评价,processDate 过户日期,visitDate 回访日期,t2.`name` 录入人,t3.`name` 录入部门,flowuser 流程人,flowdept 流程部门,signuser 签约人,t1.signdept 门店,t1.dname 门店区域,houseAddress 位置,turnRefer 转介绍,t.createDate 录入日期,t.remark 备注,t4.dPhone 店长电话
from
ht_visit t LEFT JOIN (select t.id,t.htNo,t.buy,t.buyPhone,t.seller,t.sellerPhone,t.processDate,t.flowuser,t.flowdept,t.signuser,t.houseAddress,t.signdept,t1.`name` as dname FROM v_ht_info t LEFT JOIN
(select t.signdept,t.p_id,t1.id,t1.`name` FROM (select t.signdept,t1.name,t1.id,t1.p_id from v_ht_info t LEFT JOIN b_organs t1 ON t.signdept =t1.`name`) t LEFT JOIN b_organs t1 ON t.p_id=t1.id) t1 ON t.signdept =t1.signdept ) t1
LEFT JOIN b_emp t2 ON t.userId =t2.id
LEFT JOIN b_organs t3 ON t.deptId =t3.id
LEFT JOIN (select t.name,t.phone as dPhone,t.name1,t.sysOrgan_id,t1.name as name2,t1.id from
(select t.name,t.phone,t1.name as name1,t.sysOrgan_id from b_emp t JOIN b_position t1 ON t.position_id = t1.id where t1.id=116 and t.status=243) t JOIN b_organs t1 ON t.sysOrgan_id = t1.id GROUP BY t1.id ) t4 on t1.signdept =t4.name2
这个语句 老报错,不知道什么情况 请大神帮忙看看