【SQL练习】表tab5与表tab6通过company关联，要求编写SQL语句查询每个员工工号所属的省份

表tab5与表tab6通过company关联，要求编写SQL语句查询每个员工工号所属的省份

create table tab5(
       company varchar(10),
       agencyid varchar(10),
       name varchar(20),
       dtmonth number(6),
       duty varchar(20)
);

insert into tab5(company, agencyid, name, dtmonth, duty) 
values ('平安', '001', '张三', 202508, '1');
insert into tab5(company, agencyid, name, dtmonth, duty) 
values ('招商', '001', '李四', 202508, '1');
insert into tab5(company, agencyid, name, dtmonth, duty) 
values ('平安证券', '001', '王五', 202508, '1');
insert into tab5(company, agencyid, name, dtmonth, duty) 
values ('平安', '002', '赵六', 202508, '1');
commit;

create table tab6(
       province varchar(20),
       company varchar(10),
       adearea varchar(8)
);

insert into tab6(province, company, adearea) values ('广东', '平安', '华南');
insert into tab6(province, company, adearea) values ('上海', '平安证券', '华东');
insert into tab6(province, company, adearea) values ('广东', '招商', '华南');
commit;

select t1.*, t2.province
  from tab5 t1
 inner join tab6 t2
    on t1.company = t2.company;