selection date

SELECT mti, de3 as pay_advice,de4 as amount,de61 as invoice_id,de39 as RC,de37 as 'reff_Code',de32 as 'issuer_code',de33 as 'forw_code', de42 as mobilePhone,de48 as merchantApikey, createdTime FROM new_mmt.message_iso   where de61 in 
(SELECT de61 from new_mmt.message_iso  where de39='68'  and 
(createdTime BETWEEN '2015-10-05 00:00:00' AND '2015-11-05 00:00:00')
);

SELECT mti, de3 as pay_advice,de4 as amount,de61 as invoice_id,de39 as RC,de37 as 'reff_Code',de32 as 'issuer_code',de33 as 'forw_code', de42 as mobilePhone,de48 as merchantApikey, createdTime FROM new_mmt.message_iso where de61 in
(SELECT de61 from new_mmt.message_iso where de39='68' and
(createdTime BETWEEN '2016-4-20 00:00:00' AND '2016-4-30 00:00:00')
) and mti = '0230';

Select
a.mti,
a.de3 as pay_advice,
a.de4 as amount,a.de61 as invoice_id,
a.de39 as RC,
a.de37 as 'reff_Code_iso',
b.refCode as 'reff_Code_comp',
a.de32 as 'issuer_code',
a.de33 as 'forw_code',
a.de42 as mobilePhone,
a.de48 as merchantApikey,
a.createdTime as time_
from new_mmt.message_iso a , new_mmt.transactiondetail b
-- , new_mmt.message_iso b
where a.de39='00' and
(a.createdTime BETWEEN '2016-4-20 00:00:00' AND '2016-4-30 00:00:00')
and a.mti = '0230' and a.de61 = b.invoiceID and a.DE37 != b.refCode ;