try: update gd_expert a set confirm =(select 1 from person b where a.code=b.code and a.shcool=b.univ_id and tigle_id like '1%' and rownum=1) where exists(select 1 from person b where a.code=b.code and a.shcool=b.univ_id and tigle_id like '1%' );
update gd_expert a set a.confirm=1 where exists (select 1 from person b where a.shcool=b.univ_id) and b.title_id like '1%'
update gd_expert a set a.confirm=1 where exists (select 1 from person b where a.shcool=b.univ_id) and a.shcool=b.univ_id and b.title_id like '1%'
还是少了个条件update gd_expert a set a.confirm=1 where exists (select 1 from person b where a.shcool=b.univ_id and a.code=b.code) and a.code=b.code and a.shcool=b.univ_id and b.title_id like '1%'
update gd_expert a set confirm =(select 1 from person b where a.code=b.code and a.shcool=b.univ_id and tigle_id like '1%' and rownum=1) where exists(select 1 from person b where a.code=b.code and a.shcool=b.univ_id and tigle_id like '1%' );
to ORARichard 我按照你写的 update gd_expert a set a.confirm=1 where exists (select 1 from person b where a.shcool=b.univ_id and a.code=b.code) and a.code=b.code and a.shcool=b.univ_id and b.title_id like '1%' 输入后 查询编辑器 包错:ur SQL syntax near 'a set a.confirm=1 where exists (select 1 from person b where a.shcool=b.univ_id ' at line 1
update (select a.confirm,a.code,a.shcool,b. from gd_expert a,person b where a.code=b.code and a.school=b.univ_id)set confirm=1 where title_id like '1%'
update gd_expert a set confirm =(select 1 from person b where a.code=b.code and
a.shcool=b.univ_id and tigle_id like '1%' and rownum=1)
where exists(select 1 from person b where a.code=b.code and
a.shcool=b.univ_id and tigle_id like '1%'
);
a.shcool=b.univ_id and tigle_id like '1%' and rownum=1)
where exists(select 1 from person b where a.code=b.code and
a.shcool=b.univ_id and tigle_id like '1%'
);
我按照你写的
update gd_expert a set a.confirm=1 where exists (select 1 from person b where a.shcool=b.univ_id and a.code=b.code) and a.code=b.code and a.shcool=b.univ_id and b.title_id like '1%'
输入后
查询编辑器
包错:ur SQL syntax near 'a set a.confirm=1 where exists (select 1 from person b where a.shcool=b.univ_id ' at line 1
where a.code=b.code and a.school=b.univ_id)set confirm=1 where title_id like '1%'
由QQ嘛?我的54987407想在QQ上请教请教你