通过一个表去修改另个表数据

修改MEMBER表里面的数据

UPDATE m

SET MbrPtsAwarded = x.balance
--SELECT * 
FROM dbo.Member m JOIN (
SELECT MemberId, AuditAnnual, AuditTransPtsStatus, SUM(AuditTransPts*AuditQty) AS balance FROM dbo.MemberAudit
WHERE AuditAnnual = 2013 AND AuditTransPtsStatus IS NOT NULL
GROUP BY MemberId, AuditAnnual, AuditTransPtsStatus ) x ON m.id = x.MemberId
SELECT * FROM  dbo.Member WHERE MbrPtsAwarded IS NULL