Advertisement
naimul64

Query

Jun 28th, 2018
275
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.45 KB | None | 0 0
  1. SELECT t.transaction_datetime paymentDate,
  2.   i.biller_code billerCode,
  3.   t.payment_type paymentMethod,
  4.   t.amount, 'RBL' bankCode,
  5.   br.branch_name branchName,
  6.   'RBL' bankName
  7. FROM transaction t INNER JOIN biller_info i ON t.biller_id = i.id INNER JOIN branch br ON t.branch_id = br.id
  8.   WHERE transaction_datetime >= '$P{fromDate}'
  9.   AND transaction_datetime <= '$P{toDate}'
  10.   AND branch_id = $P{branchId}
  11.   AND payment_type = '$P{paymentType}'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement