Bà con ai cần dùng thì sử dụng các Query sau:


select top 20 a.AccountID, a.Name, a.Resets, b.thehe from Character as a, MEMB_INFO as b where a.AccountID = b.memb___id and b.thehe = 2
go

//query 1
update character set Resets = Resets + 10
where AccountID in (select memb___id from MEMB_INFO where thehe = 2)

GO
//query 2
UPDATE Table1
SET Table1.Resets = Table1.Resets + 10
FROM Character AS Table1 INNER JOIN MEMB_INFO AS Table2 ON Table1.AccountID = Table2.memb___id
WHERE Table2.thehe = 2
GO

//query 3
update character set Resets = Resets + 10
where AccountID
in (select memb___id from MEMB_INFO where thehe = 2 AND (memb___id = '38148270' OR memb___id = '0924301800'))
GO

//query 4
UPDATE Table1
SET Table1.Resets = Table1.Resets + 10
FROM Character AS Table1 INNER JOIN MEMB_INFO AS Table2 ON Table1.AccountID = Table2.memb___id
WHERE Table2.thehe = 2 AND (Table2.memb___id = '38148270' OR Table2.memb___id = '0924301800')
GO

//query 5
UPDATE Table1
SET Table1.Resets = Table1.Resets + 10
FROM Character AS Table1 INNER JOIN MEMB_INFO AS Table2 ON Table1.AccountID = Table2.memb___id
WHERE (Table2.thehe = 2 AND Table2.memb___id in ('38148270','0924301800'))

GO

//su dung 1 trong 2 quey tren
va phai chinh collate cua truong memb___id (MEMB_INFO) va AccountID (character) giong nhau