forum

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

Ask Question
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

2 Answers

Nitin Lahoti

Nitin Lahoti

11-Dec-2018

I 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

Anonymous User

27-Nov-2018

Hi, Rahul

Please, use this query ...

1). If you want to 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_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