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
890
April 20, 2019 12:08PM
368
April 20, 2019 03:43PM
383
April 21, 2019 10:09AM
410
April 21, 2019 10:48AM
Re: delete with inner join doesnt work
336
April 22, 2019 03:03AM
353
April 22, 2019 08:57AM
323
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.