Skip to Content
0
Nov 18 at 07:36 AM

How to write delete statement with inner join in SAP HANA

182 Views

Hi,

Could someone help me to understand if there is any way to write delete statement with inner join condition in HANA?

I tried below statement and getting error.

DELETE from TABLE_1 A

INNER JOIN TABLE_2 B ON

A.COLUMN_1=B."COLUMN_2

Error message: sql syntax error: incorrect syntax near "INNER"

Br, Karthik