Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT a.name
- FROM Books_Readers AS br
- INNER JOIN Books AS b
- ON br.Book_kod=b.kod
- INNER JOIN Books_Authors AS ba
- ON ba.book_kod=b.kod
- INNER JOIN Authors AS a
- ON a.kod=ba.author_kod
- WHERE month(onhand) = month(GETDATE())-1
- AND (SELECT max(colcount) FROM
- (SELECT count(book_kod) AS colcount FROM Books_Readers)) =
- (SELECT count(book_kod) FROM Books_Readers)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement