DELETE InvLines FROM InvLines ; JOIN InvMast ON InvMast.ivl_Invoice = InvLines.ivl_Invoice ; WHERE InvMast.ivm_Batch = sBatchId>How do I do this with a JOIN:
> >** Delete the invoice line item records >DELETE FROM InvLines; > WHERE ivl_Invoice IN; > (SELECT ivm_Invoice; > FROM InvMast; > WHERE ivm_Batch = sBatchId) > > >