[MSSQL Query] Help needed

I have a Trickster online private server now I want to give everybody a weapon.
I know how to do that but I want weapon by lvl 10 (and give only 1 time)

My query was for so far this:

Code:

---

SELECT char_status WHERE level=('10')
UPDATE char_equip
SET weapon=('3000'),WHERE weapon=('0')

---

The error:

Code:

---

Server: Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'WHERE'.

---

You put an extra comma before the second WHERE. It should read

Code:

---

SELECT char_status WHERE level=('10')
UPDATE char_equip
SET weapon=('3000') WHERE weapon=('0')

---

BTW, you should read section 13 of the reference manual ;)

Code:

---

SELECT level=('10') FROM char_status
UPDATE weapon=('3000') WHERE weapon=('0') FROM char char_equip

---

Hmm I used this one now he see all level 10 but with that level 10 he must upgrade from table char_equip ROW weapon 3000 ...

If I understand this correctly, you have 2 tables, 1 called char_status and 1 called char_equip? And you want to update the column weapon in char_equip for all users in char_status that have level=10? And the column char is the same in both tables?

In that case:

Code:

---

UPDATE char_status LEFT JOIN char_equip ON char_status.char = char_equip.char
SET char_equip.weapon = '3000' WHERE char_equip.weapon = '0' AND char_status.level = '10'

---

Sidenote: you're a mod, you're supposed to give a good example. You didn't give nearly enough information in your topicstart and your title is meager at best. Take care to improve on these points in the future.