1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
| CREATE VIEW v_destination AS
SELECT d.dst_id AS id_destination,
d.dst_nom AS nom_destination,
v.vil_id AS id_ville,
v.vil_nom AS nom_ville,
p.pay_id AS id_pays,
p.pay_nom AS nom_pays,
c.cnt_id AS id_continent,
c.cnt_nom AS nom_continent
FROM destination d
INNER JOIN ville v ON v.vil_id = d.dst_id_ville
INNER JOIN pays p ON p.pay_id = v.vil_id_pays
INNER JOIN continent c ON c.cnt_id = p.pays_id_continent;
-- Destinations en Asie
SELECT id_destination, nom_destination,
id_ville, nom_ville,
id_pays, nom_pays
FROM v_destination
WHERE nom_continent = 'Asie';
-- Destinations en Chine
SELECT id_destination, nom_destination,
id_ville, nom_ville
FROM v_destination
WHERE nom_pays = 'Chine';
-- Destinations à Pékin
SELECT id_destination, nom_destination
FROM v_destination
WHERE nom_ville = 'Pékin'; |
Partager