Re: delete with inner join doesnt work
Posted by:
steve perp
Date: April 22, 2019 03:03AM
Hi Peter
Thanks!
But my tables T1 and T2 have the same parameter as primary key.
Thats why line 3
DELETE T1, T2
FROM T1
INNER JOIN T2 ON T1.id = T2.id
WHERE T1.name = "TG-%";
I didnt create/implemenrt a foreign key.
Is it possible to create that later/now?
Steve
Subject
Views
Written By
Posted
882
April 20, 2019 12:08PM
363
April 20, 2019 03:43PM
379
April 21, 2019 10:09AM
405
April 21, 2019 10:48AM
Re: delete with inner join doesnt work
333
April 22, 2019 03:03AM
346
April 22, 2019 08:57AM
319
April 24, 2019 03:39AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.