ขอถามเกี่ยวกับเรื่อง คำสั่ง update ของ sql 2000 หน่อยครับ

Quote:

UPDATE QUEST_TheHero
SET QUEST_TheHero.credits=credits +1
FROM Character JOIN
QUEST_TheHero ON Character.Accountid = QUEST_TheHero.memb___id COLLATE Latin1_general_CI_AS
WHERE character.clevel = 530 and Resets >2 and MapNumber = 2 and MapPosX = 207 and MapPosY = 14 and QUEST_TheHero.credits = 0

Quote:

UPDATE QUEST_TheHero
SET QUEST_TheHero.credits=credits +1 , character.clevel = 50
FROM Character JOIN
QUEST_TheHero ON Character.Accountid = QUEST_TheHero.memb___id COLLATE Latin1_general_CI_AS
WHERE character.clevel = 530 and Resets >2 and MapNumber = 2 and MapPosX = 207 and MapPosY = 14 and QUEST_TheHero.credits = 0