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
970
April 20, 2019 12:08PM
398
April 20, 2019 03:43PM
422
April 21, 2019 10:09AM
441
April 21, 2019 10:48AM
Re: delete with inner join doesnt work
380
April 22, 2019 03:03AM
387
April 22, 2019 08:57AM
359
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.