Salut,
Pouvez m'aider a debuger cette requete ?
You have written a subquery that can return more than one field without using the EXISTS reserved word in the main query's FROM clause. Revise the SELECT statement of the subquery to request only one field.
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8 DELETE * FROM delta WHERE instrument1 IN (SELECT instrument1, delta FROM delta WHERE delta <>0 GROUP BY instrument1, delta HAVING COUNT(*) > 3;);
MErci
Partager