Advertisement
Guest User

Untitled

a guest
Nov 24th, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.48 KB | None | 0 0
  1. SELECT ob1.oID, ob1.vytvorena, os1.jmeno, za1.jmeno
  2. FROM test.Objednavka ob1
  3. JOIN test.Osoba os1 ON ob1.uID = os1.uID AND os1.zeme IN ('Great Britain', 'Germany')
  4. JOIN test.Polozka pl1 ON pl1.oID = ob1.oID
  5. JOIN test.Zbozi zb1 ON zb1.zID = pl1.zID
  6. JOIN test.Zamestnanec za1 ON za1.zaID =ob1.zaID
  7. WHERE zb1.kategorie = ALL(
  8.     SELECT zb2.kategorie
  9.     FROM test.Objednavka ob2
  10.     JOIN test.Polozka pl2 ON pl2.oID = ob2.oID
  11.     JOIN test.Zbozi zb2 ON zb2.zID = pl2.zID
  12.     WHERE ob2.oID = ob1.oID
  13.     )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement