How to add(merge) three or four table in a single SQL query ?

Question

Nitin Lahoti · Answer

I would like to suggest join concept to add multiple tabe in a single query as per above post mr.SANATand  plz use this one.

Anonymous User · Answer

Hi, RahulPlease, use this query ...1). If you want toand Merge Two Tables...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_1FULL OUTER JOIN
Table_2 ON Table_1.EmployeeName = Table_2.EmployeeName
FULL OUTER JOIN 
Table_3 ON Table_2.EmployeeName = Table_3.EmployeeNameNote - 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.

forum

How to add(merge) three or four table in a single SQL query ?

Anonymous User

Can you answer this question?

2 Answers

Liked By