12 lines
312 B
SQL
12 lines
312 B
SQL
CREATE VIEW CommandeBuveur (numCom, dateCom, nomBuveur)
|
|
AS SELECT NumCom, DateCom, Nom
|
|
FROM Commande NATURAL JOIN Buveur;
|
|
|
|
CREATE VIEW VIN2 (numvin, cru, region)
|
|
AS SELECT NumVin, cru, Region
|
|
FROM Vin;
|
|
|
|
CREATE VIEW Paris (Numbuveur, nom, prenom)
|
|
AS SELECT NumBuveur,Nom, Prenom
|
|
FROM Buveur
|
|
WHERE Ville = 'PARIS'; |