Data Ciondensing

[Guest]

Hello,

I am trying to run a query to get SALES-COGS-and ASP by Product Code.

Currently, I am getting multiple lines for the same Product Code. Can I
combine the specific product codes into a single line that sums these fields?

Thanks

 

[Yumex85]

Yes you can.
select sum(the column u wanna sum) from table where
product_code_collumn = code_number

You must be getting multiple lines without doin a sum because probably
the table u r woking on, the product code column is not the primary
key.
regards,yumi