SQL查询

select id_stocpf,operat_nscomp,datemodif,SUBSTRING(heuremodif,1,6) AS TIME
from (select id_stocpf from t_stocpf where et_refcmp='655392800C' and datemodif between '20221106' and '20221111' and STOCPF_LINE='2001')s,t_operat
where s.id_stocpf=t_operat.et_stocpf
and operat_nscomp like 'P109%'