SHARE
TWEET

Untitled

a guest Sep 22nd, 2019 73 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. UPDATE
  2. icpar_app.`transaction` t1
  3. LEFT JOIN
  4. icpar.`transaction` t2
  5. ON
  6. t1.id COLLATE utf8_general_ci = t2.nid COLLATE utf8_general_ci
  7. SET
  8. t1.approval = 'pending'
  9. WHERE
  10. t2.nid IS NULL
  11. AND
  12. t1.approval = 'paid'
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top