>>Hi all,
>>
>>
>>i have Ddate.dbf ( ddate D )
>>European Date
>>
>>01/01/2005
>>02/01/2005
>>03/01/2005
>>04/01/2005
>>05/01/2005
>>06/01/2005
>>07/01/2005
>>08/01/2005
>>09/01/2005
>>
>>i have etats.dbf ( ddebut D , Dfin D )
>>
>>dDebut dfin
>>02/01/2005 04/01/2005
>>07/01/2005 08/01/2005
>>
>>I want all dates that are NOT include in etats.dbf betw MIN(ddebut ) 02/01/2005 and Max( dfin ) 08/01/2005 =>
>>EX 05/01/2005 06/01/2005
>>
>>
>>How can i do it with a sql syntaxe ?
>
>If I understand what you're looking for, try something like this:
>

>SELECT dDate ;
>  FROM dDates ;
>  WHERE NOT EXISTS ( ;
>    SELECT * FROM Etats ;
>      WHERE dDate BETWEEN dDebug AND dFIN) ;
>  INTO CURSOR NotCovered
>

>Tamar

Tamar,

VFP9 doesn't support these type of select.