Advertisement
Guest User

Untitled

a guest
Aug 21st, 2019
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.16 KB | None | 0 0
  1. UPDATE exam_req_unit eu
  2. INNER JOIN exam_req e ON e.id = eu.exam_req_id
  3. SET eu.approval = 'denied'
  4. WHERE
  5.  eu.approval = 'pending'
  6.     AND e.`year` != '2019'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement