SELECT * FROM
Table_1 FULL OUTER JOIN
Table_2 ON Table_1.colomn_name = Table_2.column_name
2). And if you want to add three or four table by a single query...
SELECT * FROM
Table_1 FULL OUTER JOIN
Table_2 ON Table_1.EmployeeName = Table_2.EmployeeName
FULL OUTER JOIN
Table_3 ON Table_2.EmployeeName = Table_3.EmployeeName
Note - Foreign keys must be used in all the tables in which the tables that we call them to join. This means that all those tables should have a common column name.
Liked By
Write Answer
How to add(merge) three or four table in a single SQL query ?
Join MindStick Community
You have need login or register for voting of answers or question.
Nitin Lahoti
11-Dec-2018I would like to suggest join concept to add multiple tabe in a single query as per above post mr.SANAT plz use this one.
Anonymous User
27-Nov-2018Hi, Rahul
Please, use this query ...
1). If you want to Merge Two Tables...
2). And if you want to add three or four table by a single query...
Note - Foreign keys must be used in all the tables in which the tables that we call them to join. This means that all those tables should have a common column name.