Advertisement
Guest User

Untitled

a guest
Jan 25th, 2015
164
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. SELECT nazwa FROM dostawca d NATURAL JOIN ksiazka k NATURAL JOIN ksiazka_tematyka kt NATURAL JOIN tematyka t
  2. where tematyka = 'TEMATYKA4' GROUP BY nazwa
  3. having count(*) = (select count(id_ksiazki)
  4. from ksiazka k, dostawca d
  5. where d.id_dostawcy = k.id_dostawcy);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement