Re: Can someone please help me with a SELECT?

That's it: SELECT a.year, a.customer, a.product, a.period, a.region, a.sales, SUM(b.sales) FROM my_table a, my_table b WHERE a.year = b.year AND a.customer = b.customer AND a.product = b.product GROUP BY a.year, a.customer, a.product, a.period, a.region, a.sales You have to join the table by itself using aliases in the from clause.