Skip to Content
0

Is there any alternative of FULL OUTER join in SAP HANA other than UNION ?

Nov 15, 2017 at 07:43 AM

119

avatar image

Hello,

I want to perform FULL OUTER join on two tables in ADT. Since HANA does not support FULL OUTER join union seems to be the best alternative. however I am not getting desired output by UNION. Is there any alternative of FULL OUTER join in SAP HANA other than UNION ?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Chaitanya More Nov 16, 2017 at 04:42 AM
0

It is resolved. All results of Full Outer Join can be achieved by UNION.

Referred this thread : https://archive.sap.com/discussions/thread/3956666

Share
10 |10000 characters needed characters left characters exceeded