Access ou MS-SQL ??
1 2 3 4 5 6 7 8 9 10
| SELECT F.NumFilm,
F.TitreFilm,
datename(m,Datelancement ) AS "Mois de sortie",
year(Datelancement ) AS "Annee en cours"
FROM FILMS F INNER JOIN "COPIES FILMS" CF
ON F.NumFilm = CF.NumFilm
INNER JOIN LANCEMENT L
ON L.NumCopi = CF.NumCopi
WHERE L.Datelancement BETWEEN '1.3.2005' AND '31.3.2005'
AND L.NomSalle IN (1,2,5,7) |
et vous pouvez toujours modifier le
WHERE L.Datelancement BETWEEN '1.3.2005' AND '31.3.2005'
par un moins performant
1 2
| WHERE datepart(m,L.Datelancement)=3
AND year(L.DateLancement)=year(getdate()) |
Partager