aaaa

BEGIN;
UPDATE sl_invoice_tax A
SET tax_no = '000.000-00.00000000 '
FROM sl_invoice_tax B
WHERE A.tenant_id = 10
AND B.tenant_id = A.tenant_id
AND B.tax_no = '010.007-21.40684275'
AND B.invoice_id =
    ( SELECT C.invoice_id
        FROM sl_invoice C
        WHERE B.tenant_id = C.tenant_id
        AND C.doc_no = 'SI/000325/KPS/202111');

SELECT * FROM sl_invoice_tax WHERE invoice_id = (
    SELECT invoice_id FROM sl_invoice WHERE tenant_id = 10
          AND doc_no = 'SI/000325/KPS/202111')

--rollback