Advertisement
Guest User

Pierre NOOB

a guest
Mar 27th, 2017
43
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. SELECT depot.n_dep
  2. FROM livraison,depot,journal
  3. WHERE livraison.n_dep = depot.n_dep AND journal.code_j = livraison.code_j AND journal.type_j = "FEMININ" AND journal.periode = "mensuel"
  4. GROUP BY depot.nom_dep
  5. HAVING COUNT(DISTINCT livraison.code_j) = (SELECT COUNT(code_j)
  6. FROM journal
  7. WHERE type_j = "FEMININ" AND periode = "mensuel")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement