select * from CI_MRuploaded by Nuno Rodrigues
select * from CI_MR where MR_ID = 'XXXX'uploaded by Nuno Rodrigues
SELECT MR.READ_DTTM, MR.MR_ID FROM CI_MR MR WHERE -- pick one of the following and remove the [ ] [MR.MTR_CONFIG_ID = 'INSERT_METER_CONFIG_ID'] [MR.MR_ID = 'INSERT_METER_ID'] AND MR.READ_DTTM <= SYSDATE ORDER BY MR.READ_DTTM DESCuploaded by Nuno Rodrigues