SHARE
TWEET

Untitled

a guest Oct 24th, 2013 70 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top