Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Brand 1 : 1
- Brand 3 : 1
- Brand 4 : 1
- Brand 6 : 1
- Brand 1 : 1
- Brand 3 : 1
- Brand 4 : 1
- Brand 6 : 1
- brand 2 : 0
- brand 5 : 0
- brand 7 : 0
- SELECT NOM_MARQUE, IFNULL(v.ID_VOITURE)
- FROM marque m, voiture v, model mo
- WHERE v.ID_MODEL = mo.ID_MODEL
- AND mo.ID_MARQUE = m.ID_MARQUE
- GROUP BY NOM_MARQUE
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement