Skip to Content
0
Former Member
Feb 16, 2014 at 05:06 PM

DELETE with INNER JOIN not working in HANA SQL

5480 Views

Hello All,

I am getting error message while executing the below SQL code.. but i think this is valid SQL statement..Please help me in resolving this issue..

DELETE sk1 from "SCHEMA"."TABLE2" sk1

inner join

"SCHEMA"."TABLE1" sk

on sk."User" = sk1."User" and

sk."Location" = sk1."Location"

If I execute the statement i am getting below error..

SAP DBTech JDBC: [257] (at 8): sql syntax error: incorrect syntax near "sk1": line 1 col 8 (at pos 8)