SELECT distinct Book.BookCode, Book.Title
FROM Branch, Copy, Book, Publisher
WHERE Branch.BranchNum=Copy.BranchNum
And Copy.BookCode=Book.BookCode
And Book.PublisherCode=Publisher.PublisherCode
And (Publisher.PublisherName='Vintage Books' Or Branch.BranchName='ABC Brentwood');
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024