>DELETE InvLines FROM InvLines ; > JOIN InvMast ON InvMast.ivl_Invoice = InvLines.ivl_Invoice ; > WHERE InvMast.ivm_Batch = sBatchId >>
>> >>** Delete the invoice line item records >>DELETE FROM InvLines; >> WHERE ivl_Invoice IN; >> (SELECT ivm_Invoice; >> FROM InvMast; >> WHERE ivm_Batch = sBatchId) >> >> >>