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')