Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT depot.n_dep
- FROM livraison,depot,journal
- WHERE livraison.n_dep = depot.n_dep AND journal.code_j = livraison.code_j AND journal.type_j = "FEMININ" AND journal.periode = "mensuel"
- GROUP BY depot.nom_dep
- HAVING COUNT(DISTINCT livraison.code_j) = (SELECT COUNT(code_j)
- FROM journal
- WHERE type_j = "FEMININ" AND periode = "mensuel")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement