SHARE
TWEET

Untitled

a guest Jun 18th, 2019 76 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Brand 1 :   1
  2. Brand 3 :   1
  3. Brand 4 :   1
  4. Brand 6 :   1
  5.      
  6. Brand 1 : 1
  7.             Brand 3 : 1
  8.             Brand 4 : 1
  9.             Brand 6 : 1
  10.             brand 2 : 0
  11.             brand 5 : 0
  12.             brand 7 : 0
  13.      
  14. SELECT NOM_MARQUE, IFNULL(v.ID_VOITURE)
  15. FROM marque m, voiture v, model mo
  16. WHERE v.ID_MODEL = mo.ID_MODEL
  17. AND mo.ID_MARQUE = m.ID_MARQUE
  18. GROUP BY NOM_MARQUE
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top