UPDATE T1 SET 销售额=T2.销售额,发货额=T3.发货额 FROM 表A T1 LEFT JOIN 表B T2 ON T1.销售部门=T2.销售部门 AND T1.统计时间=T2.统计时间 LEFT JOIN 表C T3 ON T1.销售部门=T3.销售部门 AND T1.统计时间=T3.统计时间
insert 表A select b.name,b.count_date,b.sale_price,c.send_price from 表B b inner join 表C c on b.name=c.name and b.count_date=c.count_date
good insert 表A select b.name,b.count_date,b.sale_price,c.send_price from 表B b inner join 表C c on b.name=c.name and b.count_date=c.count_date
SET 销售额=T2.销售额,发货额=T3.发货额
FROM 表A T1
LEFT JOIN 表B T2 ON T1.销售部门=T2.销售部门 AND T1.统计时间=T2.统计时间
LEFT JOIN 表C T3 ON T1.销售部门=T3.销售部门 AND T1.统计时间=T3.统计时间
insert 表A
select b.name,b.count_date,b.sale_price,c.send_price
from 表B b
inner join 表C c
on b.name=c.name and b.count_date=c.count_date
good
insert 表A
select b.name,b.count_date,b.sale_price,c.send_price
from 表B b
inner join 表C c
on b.name=c.name and b.count_date=c.count_date