WDForge.org - Forums

Re: Probleme requetes Imbriquées

Sujet: Re: Probleme requetes Imbriquées
par Totof sur 15/2/2007 17:27:23

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