Hi Naomi,

Yes, his answer is to the wrong person, this thread was started by me. :)

But the problem is, I want to optimize the query in my first post, because i need the other fields for display purposes, if i group only by c_cod_art, it's working with one row, but i need the name of the suplier, and it creates a row with QtFor with the suplier NAME (cNomFor) and other with qtCli with no name.

i need to display this in Form
QtCli=Quantity Client needs
qtFor=Quantity Orders in suplier

c_cod_art....Suplier Name....... qtCli....qtFor
AAAAA        Joao                 10        15
BBBBB        carlos               20        50
CCCCC        joao                100       200

João Batista