再次求教!!
0620 2003-10-17 01:11:07 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,所以出错!但我现在必须修改满足条件的所有记录,怎样修改以上语句。