>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
João,
Can you post some simple data and desired result from it?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.