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