You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
17 lines
344 B
17 lines
344 B
2 years ago
|
-- Query 13
|
||
|
|
|
||
|
|
SELECT
|
||
|
|
srv2.numserveur,
|
||
|
|
srv2.nomserveur,
|
||
|
|
srv2.villeserveur
|
||
|
|
FROM serveur srv1
|
||
|
|
INNER JOIN serveur srv2 ON srv1.villeserveur = srv2.villeserveur
|
||
|
|
WHERE
|
||
|
|
srv1.nomserveur = "Durant Pierre"
|
||
|
|
AND srv1.numserveur != srv2.numserveur;
|
||
|
|
|
||
|
|
/* == RESULT ==
|
||
|
|
"numserveur","nomserveur","villeserveur"
|
||
|
|
53,"Pillot Alain","BELFORT"
|
||
|
|
*/
|