Hi guys,
i want to join a table (whose data I extracted from SAP HANA) to itself . The table is named tableone
A1.left: tableone
A2.right: tableone
I would like to join it to itself, only where A2."ProductStatus" is not 'To archive'
and join on A1."Product"=A2."SystemTrigger"
Also, I want to be able to name "PRODUCTDESCRIPTION" column as "System Description"
Can someone help me code this?
