这种查询称为相关子查询.根据您的要求,查询如下….
update students s
set s.department = (
select e.qualification
from employee e
where s.uniquename = e.uniquename
and s.Homecountry = e.Homecountry
);
根据您的回复更新此帖子.
再次,继续,始终发布创建表并插入语句(和预期结果)来重现您的案例.如果您没有看到预期的结果,或者在执行查询时看到错误,请发布确切的消息,而不是仅仅说“不工作”.这是我的sqlplus会话的结果.
—创建表和插入语句
create table student(
name varchar2(20),age number,department varchar2(3),HomeCountry varchar2(10)
);
Table created.
create table employee5(
name varchar2(20),exp number,qualification varchar2(3),homecountry varchar2(10)
);
Table created.
insert into student values ('Mohan',25,'EEE','India');
insert into student values ('Raja',27,'India');
insert into student values ('Ahamed',26,'ECE','UK');