By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE T1 (ID INTEGER);
CREATE TABLE T2 (PID INTEGER, Email VARCHAR (100));
INSERT INTO T1 (ID) VALUES (1), (2), (3);
INSERT INTO T2 (PID, Email) VALUES (1, 'abcde'), (2, 'mitul'), (3, 'ijkhl');
DELETE T1
FROM T1
JOIN T2 ON T2.PID = T1.ID
WHERE T2.Email LIKE '%mitul%';
SELECT * FROM T1;
SELECT * FROM T2;
| ID |
|---|
| 1 |
| 3 |
| PID | |
|---|---|
| 1 | abcde |
| 2 | mitul |
| 3 | ijkhl |