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

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'); inser