Select 新表.订单号, 新表.数量, 新表.交货期, llx([订单号],[数量],[交货期]) AS 备注
FROM 新表
Where (((新表.订单号) In (select 订单号 from 旧表)));
UNION ALL
Select 新表.订单号, 新表.数量, 新表.交货期, "新增" AS 备注
FROM 新表
Where (((新表.订单号) Not In (select 订单号 from 旧表)));
UNION ALL Select 旧表.订单号, 旧表.数量, 旧表.交货期, "取消" AS 备注
FROM 旧表
Where (((旧表.订单号) Not In (select 订单号 from 新表)));

点击下载此附件