Advertisement
Guest User

Untitled

a guest
Oct 24th, 2013
248
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.40 KB | None | 0 0
  1. SELECT a.name
  2. FROM Books_Readers AS br
  3. INNER JOIN Books AS b
  4.       ON br.Book_kod=b.kod
  5. INNER JOIN Books_Authors AS ba
  6.       ON ba.book_kod=b.kod
  7. INNER JOIN Authors AS a
  8.       ON a.kod=ba.author_kod
  9. WHERE month(onhand) = month(GETDATE())-1
  10.   AND (SELECT max(colcount) FROM
  11.         (SELECT count(book_kod) AS colcount FROM Books_Readers)) =
  12.       (SELECT count(book_kod) FROM Books_Readers)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement