Re: Can someone please help me with a SELECT?

Belakimem wrote: > Can someone help me with a SELECT? > > I have a SELECT > > SELECT YEAR, CUSTOMER, PRODUCT, PERIOD, REGION, SALES from my_table > order by YEAR, CUSTOMER, PRODUCT, PERIOD, REGION> Hi ! In my opinion it's no way to do this in single SELECT but a have idea: 1. Create view CREATE VIEW v_my_table(yr,cust,prod,ytd_sales) as SELECT YEAR,CUSTOMER,PRODUCT,SUM(SALES) FROM my_table GROUP BY 1,2,3 2. Change your SELECT statement to join SELECT YEAR,CUSTOMER,PRODUCT,PERIOD,REGON,SALES,ytd_sales FROM my_table,v_may_table WHERE my_table.year=v_my_table.yr and my_table.customer=v_my_table.cust and my_table.product=v_my_table.prod I hope that it's what you want.