---
title: "How to add(merge) three or four table in a single SQL query ?"  
description: "How to add(merge) three or four table in a single SQL query ?"  
author: "Anonymous User"  
published: 2018-11-27  
updated: 2018-12-11  
canonical: https://www.mindstick.com/forum/34710/how-to-add-merge-three-or-four-table-in-a-single-sql-query  
category: "database"  
tags: ["database", "sql server", "join", "sql"]  
reading_time: 1 minute  

---

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

using [FULL OUTER JOIN](https://www.mindstick.com/forum/1216/full-outer-join-on-2-data-tables-with-a-list-of-columns)

[Table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap) -1 + Table-2 + Table-3

## Replies

### Reply by Nitin Lahoti

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.

### Reply by Anonymous User

Hi, Rahul

Please, use this query ...

**1).** If you wantto 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.EmployeeName
```

**Note -** Foreign keys must be used in all the tables in which the tables that we call them to [join](https://www.mindstick.com/articles/1487/join-sleep-and-interrupt-methods-in-c-sharp-threading). This means that all those tables should have a common column name.


---

Original Source: https://www.mindstick.com/forum/34710/how-to-add-merge-three-or-four-table-in-a-single-sql-query

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.