Skip to Content

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

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 ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 16, 2017 at 04:42 AM

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

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

    Add comment
    10|10000 characters needed characters exceeded