Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT dc.dce_id_comunic, dcpe.dcc_data_envio, dcpe.dcc_data_leitura,
- dc.dce_hash_xml, dce.dce_dcr_id_cpe, dc.dce_origem_param
- FROM usr_sat_dtec.dtec_comunicacao dc,
- usr_sat_dtec.dtec_ciente_eletronico dce,
- usr_sat_dtec.dtec_comunicacao_cpe dcpe
- WHERE
- dc.dce_id_comunic=dce.dce_dce_id_comunic
- AND dcpe.dcc_dce_id_comunic=dc.dce_id_comunic
- AND dcpe.dcc_dcr_id_cpe=dce.dce_dcr_id_cpe
- AND dce.dce_dce_id_estado_ciente=4
- --AND dc.dce_id_comunic!=XXXX
- ORDER BY dc.dce_id_comunic DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement