Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT concat(A.prénom," ",A.nom," a réalisé un film aux Etats-Unis")
- FROM artiste AS A
- JOIN film AS F ON (A.idArtiste=F.idRéalisateur)
- JOIN pays AS P ON (P.code=F.codePays)
- WHERE P.code="US";
- SELECT concat(A.prénom," ",A.nom," a réalisé un film aux Etats-Unis")
- FROM artiste A
- JOIN film F ON (A.idArtiste=F.idRéalisateur)
- JOIN pays P ON (P.code=F.codePays)
- WHERE P.code="US";
Add Comment
Please, Sign In to add comment