Advertisement
Guest User

Untitled

a guest
Oct 11th, 2018
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.43 KB | None | 0 0
  1. SELECT DISTINCT nom_fournisseur FROM Fournisseurs F
  2. INNER JOIN Catalogue C
  3. ON C.id_fournisseur = F.id_fournisseur
  4. INNER JOIN Articles A
  5. ON A.id_article = C.id_article
  6. WHERE couleur_article != 'noir' AND F.id_fournisseur IN (SELECT F.id_fournisseur FROM Fournisseurs F
  7. INNER JOIN Catalogue C
  8. ON C.id_fournisseur = F.id_fournisseur
  9. INNER JOIN Articles A
  10. ON A.id_article = C.id_article
  11. WHERE couleur_article != 'argente')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement