34,575
社区成员
发帖
与我相关
我的任务
分享
SELECT a.Yg_Name,a.Yg_Bm,a.bt,
b.htmoneyHj 业绩金额,
(b.htmoneyHj * 1.0 * c.TcBl / 100) AS 提成金额
FROM yuangong a
LEFT JOIN (SELECT jbr,sum(htmoney) AS htmoneyHj FROM Yewu GROUP BY jbr) b
ON a.Yg_Name = b.jbr
LEFT JOIN (select TcName,TcBl,TcDx,TcYj1,TcYj2 from Tc) c
ON b.htmoneyHj BETWEEN c.TcYj1 AND c.TcYj2
SELECT a.Yg_Name,a.Yg_Bm,a.bt,
b.htmoneyHj 业绩金额,
(b.htmoneyHj * 1.0 * c.TcBl / 100) AS 提成金额
FROM yuangong a
LEFT JOIN (SELECT jbr,sum(htmoney) AS htmoneyHj FROM Yewu WHERE gs='001' GROUP BY jbr) b
ON a.Yg_Name = b.jbr
LEFT JOIN (select TcName,TcBl,TcDx,TcYj1,TcYj2 from Tc WHERE gs='001') c
ON b.htmoneyHj BETWEEN c.TcYj1 AND c.TcYj2
WHERE a.gs='001'
SELECT a.Yg_Name,a.Yg_Bm,a.bt,
b.htmoneyHj 业绩金额,
(b.htmoneyHj * 1.0 * c.TcBl / 100) AS 提成金额
FROM( select * from yuangong where gs=100)a
LEFT JOIN (SELECT jbr,sum(htmoney) AS htmoneyHj FROM Yewu where gs=100 GROUP BY jbr) b
ON a.Yg_Name = b.jbr
LEFT JOIN (select TcName,TcBl,TcDx,TcYj1,TcYj2 from Tc where gs=100) c
ON b.htmoneyHj BETWEEN c.TcYj1 AND c.TcYj2