---
title: "HOW TO USE SQL FULL OUTER JOIN"  
description: "HOW TO USE SQL FULL OUTER JOIN"  
author: "Anonymous User"  
published: 2015-12-19  
updated: 2015-12-19  
canonical: https://www.mindstick.com/forum/33754/how-to-use-sql-full-outer-join  
category: "database"  
tags: ["sql server", "sql", "sql server 2008", "sql server 2012"]  
reading_time: 1 minute  

---

# HOW TO USE SQL FULL OUTER JOIN

I Want to use [Sql](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database) [full outer join](https://www.mindstick.com/forum/1216/full-outer-join-on-2-data-tables-with-a-list-of-columns) .please help me.

## Replies

### Reply by Anonymous User

The [FULL](https://www.mindstick.com/articles/12893/experience-the-full-power-of-suitecrm) [OUTER JOIN](https://www.mindstick.com/forum/159328/mysql-outer-join-syntax-error) keyword returns all rows from the left table (Customer) and from the right table ([Order]).\
The FULL OUTER JOIN keyword combines the result of both LEFT and RIGHT joins.

```
SELECT column_name(s)FROM tbl1FULL OUTER JOIN tbl2ON tbl1.column_name=tbl2.column_name;
```

![HOW TO USE SQL FULL OUTER JOIN](https://www.mindstick.com/mindstickforums/73fb3f4b-31f6-499c-a49d-a8574133b189/images/d31d84b6-b15f-4abc-a843-88c33b69c556.png)

```
ExampleSELECT  Customer.CustomerID,Customer.CustomerName, [Order].OrderID,[Order].amount
FROM Customer
FULL OUTER JOIN [Order]
ON Customer.CustomerID=[Order].CustomerID
ORDER BY Customer.CustomerName;
```

![HOW TO USE SQL FULL OUTER JOIN](https://www.mindstick.com/mindstickforums/73fb3f4b-31f6-499c-a49d-a8574133b189/images/001e5b1c-0916-4ee1-81ca-e71512cf4228.png)


---

Original Source: https://www.mindstick.com/forum/33754/how-to-use-sql-full-outer-join

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