追溯查询包装工位修改记录

SELECT * from t_simo where ET_MODEOP in
(
SELECT id_modeop from t_modeop where et_PROD_POSTE='3080-20100' and et_tyoper='OPE'
) order by DATEMODIF