Bonjour,

Auriez-vous une idée pour optimiser cette query ?
Je n'aime pas trop la succession de AND/OR mais je ne sais pas si il y a moyen de faire autrement.

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
UPDATE Table1 SET Table1.ChiffreGagnants = Table1.ChiffreGagnants +1
WHERE 
Table1.num1 IN (1,2,3,4,5,6) 
OR Table1.num2 IN (1,2,3,4,5,6) 
OR Table1.num3 IN (1,2,3,4,5,6) 
OR Table1.num5 IN (1,2,3,4,5,6) 
OR Table1.num6 IN (1,2,3,4,5,6) 
OR Table1.num7 IN (1,2,3,4,5,6)
OR Table1.num8 IN (1,2,3,4,5,6)
OR Table1.num9 IN (1,2,3,4,5,6)
OR Table1.num10 IN (1,2,3,4,5,6)
AND
 (
 Table1.num1 AND Table1.num2 AND Table1.num3 AND Table1.num4 AND Table1.num5 AND Table1.num6 AND Table1.num7 AND Table1.num8 AND Table1.num9 AND Table1.num10 NOT IN (SELECT Tirage.num1 FROM Tirage)
AND
Table1.num1 AND Table1.num2 AND Table1.num3 AND Table1.num4 AND Table1.num5 AND Table1.num6 AND Table1.num7 AND Table1.num8 AND Table1.num9 AND Table1.num10 NOT IN (SELECT Tirage.num2 FROM Tirage)
AND
Table1.num1 AND Table1.num2 AND Table1.num3 AND Table1.num4 AND Table1.num5 AND Table1.num6 AND Table1.num7 AND Table1.num8 AND Table1.num9 AND Table1.num10 NOT IN(SELECT Tirage.num3 FROM Tirage)
AND
Table1.num1 AND Table1.num2 AND Table1.num3 AND Table1.num4 AND Table1.num5 AND Table1.num6 AND Table1.num7 AND Table1.num8 AND Table1.num9 AND Table1.num10 NOT IN(SELECT Tirage.num4 FROM Tirage)
AND
Table1.num1 AND Table1.num2 AND Table1.num3 AND Table1.num4 AND Table1.num5 AND Table1.num6 AND Table1.num7 AND Table1.num8 AND Table1.num9 AND Table1.num10 NOT IN(SELECT Tirage.num5 FROM Tirage)
AND
Table1.num1 AND Table1.num2 AND Table1.num3 AND Table1.num4 AND Table1.num5 AND Table1.num6 AND Table1.num7 AND Table1.num8 AND Table1.num9 AND Table1.num10 NOT IN (SELECT Tirage.num6 FROM Tirage)
);
Il s'agit d'une requête qui update le champ "ChiffreGagnants" de la Table1 à condition que les valeur soit comprise entre 1 et 6 et à l'autre condition que ce tirage n'ai pas encore eu lieu dans la table "Tirage".

Merci d'avance à tous