select A.MachineID,B.CrtorDT,A.Leve,A.Qty
from RoughBarLst A
INNER JOIN RoughBar B ON B.BarCode = A.BarCode
where B.CrtorDT>='2021-12-01 00:00:00' and B.CrtorDT<='2021-12-31 23:59:59'
and a.Leve IN ('A1','A2','A3')
order by a.MachineID,b.CrtorDT
上面代码得出下面表格数据
从这张表格中查询相同A.MachineID的连续三天的数据,如下图黄色区域部分。