Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table_1 (id, name, gender, age) AS 
    SELECT 134, 'Rohit' , 'M', 22 FROM dual UNION ALL
    SELECT 214, 'Ayush' , 'M', 21 FROM dual UNION ALL
    SELECT 221, 'Nikhil', 'M', 24 FROM dual UNION ALL
    SELECT 112, 'Astha' , 'F', 23 FROM dual ;
4 rows affected

CREATE TABLE table_2 (id, name, gender, age, phone_num) AS 
    SELECT 134, 'Rohit' , 'M', 22, 1232   FROM dual UNION ALL
    SELECT 215, 'Ankit' , 'M', 21, 1321   FROM dual UNION ALL
    SELECT 221, 'Nikhil', 'M', 24, 1232   FROM dual UNION ALL
    SELECT 135, 'Abced' , 'F', 23, 123223 FROM dual;
4 rows affected

CREATE TABLE table_3 (id, phone_num) AS 
    SELECT 132, 234323  FROM dual UNION ALL
    SELECT 214, 1234    FROM dual UNION ALL
    SELECT 221, 1234234 FROM dual UNION ALL
    SELECT 115, 1234532 FROM dual;
4 rows affected

INSERT INTO table_2
SELECT table_1.id, table_1.name, table_1.gender, table_1.age, table_3.phone_num
FROM table_1
INNER JOIN table_3 ON table_1.id = table_3.id
WHERE table_1.id NOT IN (SELECT id FROM table_2);
1 rows affected

SELECT *
FROM table_2;


ID
NAME
GENDER
AGE
PHONE_NUM


134
Rohit
M
22
1232

215
Ankit
M
21
1321

221
Nikhil
M
24
1232

135
Abced
F
23
123223

214
Ayush
M
21
1234

ID	NAME	GENDER	AGE	PHONE_NUM
134	Rohit	M	22	1232
215	Ankit	M	21	1321
221	Nikhil	M	24	1232
135	Abced	F	23	123223
214	Ayush	M	21	1234