select menu_topic,temper_id from menuInfo,temper where temper_id=menu_id
update menuInfo set menu_topic where menu_topic in(select menu_topic,temper_id from menuInfo,temper where temper_id=menu_id )哪错了
update menuInfo set menu_topic where menu_topic in(select menu_topic,temper_id from menuInfo,temper where temper_id=menu_id )哪错了
如果是变量要改为:
"select menu_topic,temper_id from menuInfo,temper where temper_id = '" + menu_id + "'"
如果是SqlCommand中的参数,要改为:
select menu_topic,temper_id from menuInfo,temper where temper_id = @menu_id
where menu_topic in(select menu_topic,temper_id from menuInfo,temper where temper_id=menu_id )你确定只返回一个menu_topic?
update menuInfo set menu_topic=temper_topic //temper_topic 为temper中一列
列名 'temper_topic' 无效。
没有更新到,这里set menu_topic 干嘛呢?都没有动作