sql-server - 创建视图：错误 MSG 156，级别 15，状态 1

Question

CREATE VIEW titles_borrowed
AS 
    SELECT b.booktitle, o.bookid
    FROM books b 
    INNER JOIN o borrowed ON b.bookid = o.bookid 

当我尝试运行它时出现以下错误：

消息 208，级别 16，状态 1，过程titles_borrowed，第 4 行 [批处理开始第 5 行]
无效的对象名称“o”

标签： sql-server

Answer 1

你需要切换 o 并借用：

CREATE VIEW titles_borrowed
AS SELECT b.booktitle,o.bookid
FROM books b 
INNER JOIN borrowed o 
ON b.bookid = o.bookid

首先是表，然后是别名。