再次求教！！

[0620]

update S_tbl set Grade=(select Grade from S_b_tbl where bianhao in ('139','140')), Sign=(select Sign from S_b_tbl where bianhao in ('139','140')),ClassNo=(select ClassNo from S_b_tbl where bianhao in ('139','140')) where bianhao in ('139','140')

以上语句子查询中由于有in,所以出错！但我现在必须修改满足条件的所有记录，怎样修改以上语句。

[yoki]

update S_tbl
set Grade=a. Grade,
Sign=a.Sign,
ClassNo=a.ClassNo
from S_b_tbl a ,S_tbl b
where a.bianhao=b.bianhao and a.bianhao in ('139','140'))

[yujohny]

update A
set A.Grade=B.Grade,
A.[Sign]=B.[Sign],
A.ClassNo=B.ClassNo
from S_tbl A inner join S_b_tbl B where B.bianhao=A.bianhao
where A.bianhao='139' or A.bianhao='140'

用or比in好

[zhbname]

up

[shuiniu]

yujohny(踏网无痕):用or比in好?
---------------------------
就修改楼主的语句,用
where A.bianhao='139' or A.bianhao='140'
或
where a.bianhao=b.bianhao and a.bianhao in ('139','140'))
完全一样的!
个人意见

[shuiniu]

因为没有涉及导子查询:in(select....)
sql server 再内部处理的时候
将a.bianhao in ('139','140') 转化为 A.bianhao='139' or A.bianhao='140'!

[yujohny]

那SQL语句要处理转化这一步，所以个人认为能写为or要直接写，少用in

[verybigmouthz]

同意 yujohny(踏网无痕)