SAP HANA SQL Dates Aggregation

[soujanya23.]

I've an trouble with a query i've written for sap hana.

There is basically tables.

First table is a dates desk which incorporates dates for every unmarried day in a calendar. 2nd desk is a consequences table containing a customer reference range and for each consumer reference range a start date and give up date. on this client ref table, i have approximately four million statistics. So essentially within the internal part of the query i'd be getting 4 million records for each day seeing that 01012011. There need to be a simple manner SAP HANA Admin of aggregating the consequences. i have attempted an internal pick out query but it looks as if hana is having performance issues.

i have written the code like this, however this is not most useful.