1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| CREATE VIEW AvisValide (id_prod, id_int, note)
AS
SELECT av.id_prod, av.id_int, av.note
FROM AVIS av
WHERE av.validation = 'oui';
CREATE VIEW VUE (id_prod, nom_prod, img_prod, id_marq, nom_marq, id_typ, nom_typ, moyenne_note)
AS
SELECT x.Id_Prod, x.Nom_Prod, x.Img_prod, y.Id_Marq, Nom_Marq, u.Id_Typ, u.Nom_Typ, AVG(Note) AS Moyenne
FROM PRODUIT AS x LEFT JOIN APPARTIENT AS y ON x.IdMarq = y.IdMarq
LEFT JOIN AvisValide AS z ON x.Id_Prod = z.id_Prod
LEFT JOIN MARQUE AS t ON y.Id_Marq = t.Id_Marq
LEFT JOIN AVOIR AS f ON f.id_prod=x.id_prod
LEFT JOIN TYP AS u ON y.Id_typ = u.Id_typ
WHERE y.IdCat = 'cat01'
GROUP BY x.Id_Prod, x.Nom_Prod, x.Img_prod, y.Id_Marq, Nom_Marq, u.Id_Typ, u.Nom_Typ |
Partager