ora 00942错误：表或​​视图不存在

Question

Select lname, fname, title as "Book Title" 
from books join line 
on books.bookid = book_author.bookid 
join author 
on author.authorid = book_author.authorid; 

它一直说表或视图不存在，但当我从书籍中选择*时;它确实让我看到了桌子。

Answer 1

Select author.lname, author.fname, books.title as "Book Title" 
from books join book_author --line 
on books.bookid = book_author.bookid 
join author 
on author.authorid = book_author.authorid; 

line已被评论。应改为book_author。还包括select子句中的列名之前的表名