下列代码为创建图书视图的代码,请选择所缺少的部分代码。(_______________)v_book (barcode,bookname,author,price,booktype)(_______________) barcode,bookname,author,price,typenameFROM tb_bookinfo AS b ,tb_booktype AS t WHERE b.typeid=t.id;
A. CREATE VIEW、AS SELECT
B. CREATE VIEW、SELECT
CREATE TABLE、AS SELECT
D. CREATE TABLE、SELECT