Jonvy

导航

参数修改记录查询

1.
select * from t_nomen where et_refakf_se in('665930800A','650626300-1','655278300A') and et_typtra='U' and et_refakf_comp is null //查询出id_nomen:349440,105525,144156


3.
select * from t_simo where et_nomen in(349440,105525,144156) and et_modeop_pere is null and simo_fin_validite is null and et_modeop=12783//查询出id_simo:554048,513736
2
select * from t_modeop where et_prod_poste ='3081-215' and modeop_ordre_plc=1 and et_tyoper='OPE' //id_modeop=12783
4.
select * from t_carath where et_simo in (215689,307881) and et_dbnum=2155 order by et_simo,dbconfig_item

 

 

posted on 2023-12-12 17:11  不亮  阅读(2)  评论(0编辑  收藏  举报