JOIN two datasets/relations by range values


#1

Hello All,

I have a scenario where I need to join the two datasets but with range of values.

Example: Sales table have a field ‘actual’ which need to lookup into a SalesTarget table to get the rating field by if the sales.actual value falls between salestarget.start and salestarget.end.

Hope it explains my requirement.

Thanks !!