sql语句从两张表中选择数据

Question

文章表A中有字段id，authorid，title；作者表B中有id，name；其中表A中的authorid是表B中的id（一篇文章对应一个作者）。现想要一条语句从A中选择id，title还有B中的作者name ，怎么写，选出所有的文章。

Answer 1

drop table a;
drop table b;
purge recyclebin;

create table a (id number,authorid number,title varchar2(10));
create table b (id number,name varchar2(10));
insert into a values(1,1,'book1');
insert into a values(2,1,'book2');
insert into a values(3,2,'book3');
insert into a values(4,3,'book4');
insert into b values(1,'writer1');
insert into b values(2,'writer2');
insert into b values(3,'writer3');
commit;
select * from a;
select * from b;

SELECT A.ID, A.TITLE, B.NAME FROM A, B WHERE A.AUTHORID = B.ID;本回答被提问者采纳