>hi Boris,
>
>i have a little problem....
>
>if i want ALL R1.Cnomcustomer but also R1.Cnomcustomer without Etats...
>
>it's possible ?
As Peter said change INNER JOIN to LEFT JOIN:
....
FROM Amline!Resident R1;
INNER JOIN
...
FROM Amline!Resident R1;
LEFT JOIN
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.