>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
What was SQL you tried? Do you have NULLs in your data?
If it's not broken, fix it until it is.
My Blog