Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT t.transaction_datetime paymentDate,
- i.biller_code billerCode,
- t.payment_type paymentMethod,
- t.amount, 'RBL' bankCode,
- br.branch_name branchName,
- 'RBL' bankName
- FROM transaction t INNER JOIN biller_info i ON t.biller_id = i.id INNER JOIN branch br ON t.branch_id = br.id
- WHERE transaction_datetime >= '$P{fromDate}'
- AND transaction_datetime <= '$P{toDate}'
- AND branch_id = $P{branchId}
- AND payment_type = '$P{paymentType}'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement