select2.sql

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

SELECT BkName, BkYear, PubName
    FROM Book, Publisher
    WHERE Book.PubNo = Publisher.PubNo
      AND BkISBN IN (
	    SELECT Book.BkISBN
            FROM Book, Authorship, Author
            WHERE Book.BkISBN = Authorship.BkISBN
              AND Authorship.Autno = Author.Autno
              AND AutLoc = 'UK');