1 2 3 4 5 6 7 8 9 10
| 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 AVIS 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