Skip to Content
0
Jan 14, 2017 at 11:21 AM

join two tables based on quantity field value

38 Views

expected output:

I am able to get the above result using looping or iteration in hana but it degrades the performance.

Could you please let me know how to do with the select statement to achieve the above result. Is it really possible with the select statement ?

Thanks

shashi

Attachments

untitled.png (19.9 kB)
untitled3.png (10.2 kB)