I want to delete some records from a table using Join in EXAsol.
I am trying -
Delete tran
FROM
Transactions tran
INNER JOIN
Employees e
ON tran.ID = e.Transaction_ID
WHERE e.Name = 'Abhisar';
The error I am getting is -
syntax error, unexpected identifier_chain2, expecting FROM_ or '*' [line 1,column 8]
This is as good as JOIN and uses index internally. You may verify it if you enable profiling and check it after query execution.