a guest Dec 13th, 2018 52 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- select lbt.recId, lbt.splitbill, lbt.billid, lbmt.totalAmount, lbmt.TOTALTAX, lbmt.paidAmount, lbmt.PAIDTAX, lbmt.totalnetwriteoff, lbmt.TOTALTAXWRITEOFF
- from legalbilltable lbt
- INNER JOIN legalbillmattertable lbmt ON (lbmt.billreference = lbt.recid)
- where billid IN ('BN1-00000199', 'BN1-00000205')
RAW Paste Data