select distinct t1.日期1,t1.收入,t2.错送 from (select distinct YEAR(tb_DingDan.RiQi) as 日期1,sum(ShouRu) as 收入 from tb_DingDan group by YEAR(tb_DingDan.RiQi) )as t1,
(select distinct YEAR(tb_ShangPinCuoSong.RiQi )as 日期2,sum(tb_ShangPinCuoSong.ZongJia) as 错送 from tb_ShangPinCuoSong group by YEAR(tb_ShangPinCuoSong.RiQi ) )as t2
where t1.日期1=t2.日期2
(select distinct YEAR(tb_ShangPinCuoSong.RiQi )as 日期2,sum(tb_ShangPinCuoSong.ZongJia) as 错送 from tb_ShangPinCuoSong group by YEAR(tb_ShangPinCuoSong.RiQi ) )as t2
where t1.日期1=t2.日期2