>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