表A中有字段
a
01
02
03表B中有字段
a , b
01, 100
02, 200
03, 300
04, 400我想创建得到一个视图显示的结果为
a , b
01, 100
02, 200
03, 300
也就是表A中有的值,才把表B中的相对应的b字段附加进视图中请问下要如何实现创建视图呢?
a
01
02
03表B中有字段
a , b
01, 100
02, 200
03, 300
04, 400我想创建得到一个视图显示的结果为
a , b
01, 100
02, 200
03, 300
也就是表A中有的值,才把表B中的相对应的b字段附加进视图中请问下要如何实现创建视图呢?
我把原题改了下:create table a
(
a varchar2(10),
b varchar2(10),
c varchar2(10)
);
create table b
(
a varchar2(10),
b varchar2(10),
c varchar2(10),
d varchar2(10)
);drop table a;
drop table b;
select * from a;
select * from b;insert into a values('001','022','043');
insert into a values('002','053','024');
insert into a values('003','054','035');
insert into a values('005','048','005');
insert into a values('007','057','054');
insert into a values('004','066','046');insert into b values('001','0d2','0e3','540');
insert into b values('002','023','0q4','340');
insert into b values('003','044','0r5','620');
insert into b values('004','0w5','0e6','880');
insert into b values('008','012','0a5','524');
insert into b values('004','005','006','800');
insert into b values('005','0f4','0h5','190');
insert into b values('007','0e5','0s6','320');
insert into b values('008','0r4','0l5','550');
insert into b values('006','0k5','0j6','650');select * from a;
select * from b;