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 |