nouveau probleme avec les requetes imbriquée sous wd11.
Cette requete ne passe pas, il a une ( inattendu et ca bloque tout.

SELECT count(eve.sigtie) as resultat,tie.SIGREP
FROM EVE,TIE WHERE EVE.ACHVTE='V'
AND EVE.CODSOC=20 AND EVE.TYPEVE IN ('FAD','FAV','AVV','AVE','FRA','ARA','AVD')
AND EVE.CODETA!='A' and EVE.DATEVE between {Param1} and {Param2}
and tie.sigtie=eve.sigtie and tie.codsoc=eve.codsoc and tie.typtie='CLI'
and tie.sigtie=any (select sigtie from eve where codsoc=20 and EVE.TYPEVE IN ('FAD','FAV','AVV','AVE','FRA','ARA','AVD')
and codeta<>'A' and dateve between {Param3} and {Param4})
group by tie.sigrep

Si kelkun sait comment lui faire accepter cette requete ou comment il faut la modifier.
WD11 gere t'il les sous-requetes ?

Merci

Bonjour,

Ne faut il pas plutot mettre un "IN" ?

SELECT count(eve.sigtie) as resultat,tie.SIGREP
FROM EVE,TIE WHERE EVE.ACHVTE='V'
AND EVE.CODSOC=20 AND EVE.TYPEVE IN ('FAD','FAV','AVV','AVE','FRA','ARA','AVD')
AND EVE.CODETA!='A' and EVE.DATEVE between {Param1} and {Param2}
and tie.sigtie=eve.sigtie and tie.codsoc=eve.codsoc and tie.typtie='CLI'
and tie.sigtie IN (select sigtie from eve where codsoc=20 and EVE.TYPEVE IN ('FAD','FAV','AVV','AVE','FRA','ARA','AVD')
and codeta<>'A' and dateve between {Param3} and {Param4})
group by tie.sigrep


Bon dév.,

Totof