语句1:select 订单号, sum(出货数量) as 出货总数 from 出货记录 group by 订单号
语句2:select 订单号, sum(订单总数) as 订单总数 from 订单表 WHERE DateDiff(m, 订单日期, GetDate()) <24 group by 订单号
语句3:select * from (语句2) as a left join (语句1) as b on a.订单号=b.订单号 where a.订单总数 <> b.出货总数