>>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.