关于sql语句 update的问题

Question

这个更新语句，能不能在 where条件用上双条件
比如：

UPDATE Result SET A = A+1 WHERE (Result.SNo,Result.CNo) = all(select TempInfo.SNo,TempInfo.CNo from Student,TempInfo where Student.SNo=TempInfo.SNo and Student.BtAddress=TempInfo.BtAddress )
可是这样报错。
一般的更新语句都是单条件，能不能改成复合的条件！
如果是单条件能成功，就是这样：

UPDATE Result SET A = A+1 WHERE (Result.SNo) = any(select TempInfo.SNo from Student,TempInfo where Student.SNo=TempInfo.SNo and Student.BtAddress=TempInfo.BtAddress )

但是我现在需要符合符合where后两个条件

这个要怎么改才能成功！

多谢各位了！

Answer 1

UPDATE Result SET A = A+1 WHERE (Result.SNo) = any(select TempInfo.SNo from Student,TempInfo where Student.SNo=TempInfo.SNo and Student.BtAddress=TempInfo.BtAddress )

and Result.CNo = any(select TempInfo.SNo from Student,TempInfo where Student.SNo=TempInfo.SNo and Student.BtAddress=TempInfo.BtAddress )

你是想这样？