SELECT a.id, a.cos_id, b.trx_name AS trxName, a.trx_number AS trxNumber, a.trx_date AS trxDate, c.bpart_name AS customerName,
       d.currency_code AS currencyCode, a.val, e.trx_name AS refTrxName, a.ref_trx_number AS refTrxNumber, a.ref_trx_date AS refTrxDate, a.trx_dscr AS trxDscr
FROM eart010 a
    LEFT JOIN bmas010 b ON b.id = a.trx_code_id
    LEFT JOIN emsm633 c ON c.id = a.cust_id
    LEFT JOIN bmas110 d ON d.id = a.curr_id
    LEFT JOIN bmas010 e ON e.id = a.ref_trx_code_id
WHERE a.cos_id = '4e2b424769d54cac082299a4f3dd5640'
  AND a.trx_yrmo BETWEEN '201801' AND '201907'

UNION ALL

SELECT a.id, a.cos_id, b.trx_name AS trxName, a.trx_number AS trxNumber, a.trx_date AS trxDate, c.bpart_name AS customerName,
       d.currency_code AS currencyCode, a.val, e.trx_name AS refTrxName, a.ref_trx_number AS refTrxNumber, a.ref_trx_date AS refTrxDate, a.trx_dscr AS trxDscr
FROM eart020 a
    LEFT JOIN bmas010 b ON b.id = a.trx_code_id
    LEFT JOIN emsm633 c ON c.id = a.cust_id
    LEFT JOIN bmas110 d ON d.id = a.curr_id
    LEFT JOIN bmas010 e ON e.id = a.ref_trx_code_id
WHERE a.cos_id = '4e2b424769d54cac082299a4f3dd5640'
  AND a.trx_yrmo BETWEEN '201801' AND '201907'
ORDER BY trxName, trxDate, trxNumber