Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- begin;
- UPDATE sl_invoice_tax
- SET tax_no = '000.000-00.00000000 '
- WHERE tenant_id = 10
- AND invoice_id = (
- select invoice_id from sl_invoice where tenant_id = 10
- AND doc_no = 'SI/000325/KPS/202111')
- AND tax_no = '010.007-21.40684275';
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement