select2.sql

python web programming 部分

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');