Evra70

a

Dec 9th, 2021
691
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. begin;
  2. UPDATE sl_invoice_tax
  3. SET tax_no = '000.000-00.00000000 '
  4. WHERE  tenant_id = 10
  5. AND invoice_id = (
  6.     select invoice_id from sl_invoice where tenant_id = 10
  7.           AND doc_no = 'SI/000325/KPS/202111')
  8. AND tax_no = '010.007-21.40684275';
  9.  
  10. select * from sl_invoice_tax where invoice_id = (
  11.     select invoice_id from sl_invoice where tenant_id = 10
  12.           AND doc_no = 'SI/000325/KPS/202111')
  13.  
  14. --rollback
RAW Paste Data