>>>What's the exact syntax for a SQL to get all the parent which do not have any children?
>>
>>You mean like:
>>
>>Select * from parent;
>>where fieldx not in;
>>(select fieldx from child)
>
>Yes, what I have is this:
>
>SELECT COULEUR FROM COULEE;
> WHERE NOT EXIST (SELECT NOCOULEE FROM INVENTAI WHERE NOCOULEE=COULEE.NOCOULEE);
> INTO CURSOR TEMP2
>
>But, I was wondering if there was a simplier/faster way with the new INNER/OUTER/RIGHT/LEFT join.

Good question, I'll bet there is -- but I'm still using old-fashioned method like you...