Hi Nadya,

>What kind of result do you want to recieve? Are you surprised by Nulls?

No, no problem with the nulls,

>By the way, I always put tables names in join expression, even if the field
>names are unique (in this case it's not needed, but desired).

I know that, this's a test...

>Do you want to select all fields from both tables?

No, but in this test there is no problem, i want to join the name field from tbl_gc_codarmazens, and the select only gives me the result from the 1st table, no join's in the recordset.

Thank's

João