select1.sql

来自「python web programming 部分」· SQL 代码 · 共 6 行

SELECT AutFirst, AutLast, Publisher.PubName
    FROM Author, Authorship, Book, Publisher
    WHERE Author.AutNo = Authorship.Autno
      AND Authorship.BkISBN = Book.BkISBN
      AND Book.PubNo = Publisher.PubNo;