Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 '201812'
- UNION
- 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 '201812'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement