Zteam s8ep2 query

Hi Rz anyone know what is sql query to add 10000credits to all account with 5rr ? Tnx
sql 2008 r2
Zteam season8 ep2

Thanks

Quote:

---

Originally Posted by samsunggon

Hi Rz anyone know what is sql query to add 10000credits to all account with 5rr ? Tnx
sql 2008 r2
Zteam season8 ep2

Thanks

---

uppp tnx

This should work:

Code:

---

UPDATE cred SET credits = credits + 10000
FROM MEMB_CREDITS cred
JOIN Character char ON cred.memb___id = char.AccountID
WHERE char.RESETS >= 5

---