1 2 3 4 5 6 7 8 9 10 11 12
|
SELECT R1.Date, R1.Heure, R1.[Heure fin], R1.Gymnase, R1.[Dom/Ext],
R1.Equipe, R1.[N° de Match], R1.Adversaire, R1.Championnat, R1.Saison
FROM [R Equipes Matchs 3] AS R1 INNER JOIN [R Equipes Matchs 3] AS R2
ON (R1.Date = R2.Date) AND (R1.Gymnase = R2.Gymnase) AND
(R1.[Dom/Ext] = R2.[Dom/Ext])
WHERE (((R1.Heure) Between [R2].[heure] And [R2].[heure fin])) OR
(((R1.[Heure fin]) Between [R2].[heure] And [R2].[heure fin])) OR
(((R1.Heure)<[R2].[Heure]) AND ((R1.[Heure fin])>[R2].[Heure fin]))
GROUP BY R1.Date, R1.Heure, R1.[Heure fin], R1.Gymnase, R1.[Dom/Ext],
R1.Equipe, R1.[N° de Match], R1.Adversaire, R1.Championnat, R1.Saison
HAVING (((Count(R1.Date))>1)); |
Partager