Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. SELECT DISTINCT
  2. c.transaction_id, c.property_id, c.ward_id,w.ward_no, c.holding_no, c.collector_id, t.payment_mode, t.date, t.payment_ref, t.dd_date, t.bank_name, t.branch, t.amount, t.discount, t.transaction_no, t.pos_no, t.sms_status,
  3. t.remarks, ch.id AS cheque_id, ch.check_no, ch.bank, ch.check_date, ch.amount AS chk_amount, ch.reconcilation_date, ch.chk_status, ch.status AS isValid, ch.bank_reconcilation_date, t.penalty
  4. FROM dbo.tbl_collection_master AS c INNER JOIN
  5. dbo.tbl_transaction_master AS t ON c.transaction_id = t.id LEFT OUTER JOIN
  6. dbo.tbl_cheque_details AS ch ON t.id = ch.transaction_id left join tbl_Ward_Master w on w.id=c.ward_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement