SELECT

b.id,

c.ks,

c.js

FROM

b

INNER JOIN (

-- 算每个ID的开始/结束时间

SELECT

id,

max(t) AS ks,

min(t) AS js

FROM

a

GROUP BY

id

) c ON a.id = b.id

——————————————————————————

select * from (select A.*,B.* from A left join B on A.id=B.id)  where  A1  between '${开始时间}' and '${结束时间}' AND B1='${物料编号}'  

什么数据库？

写法没错，但是你这个（）外面没有写别名，那就不要用别名

with B as (

select * from B where B1='${物料编号}'  

)

select A.*,B.* from A left join B on  A.id=B.id  where  A. A1  between '${开始时间}' and '${结束时间}'