Hi Naomi,

>As I suggested, try to add MAX(cNomFor) as Supplier in your original SQL if >always one record has data and another doesn't.

I try, but didn't work. Any other choice.
Note: This's SQL Server

Joao Batista