---
title: "SQL INNER JOIN Keyword."  
description: "SQL INNER JOIN Keyword."  
author: "Anonymous User"  
published: 2015-11-05  
updated: 2015-11-05  
canonical: https://www.mindstick.com/forum/33572/sql-inner-join-keyword  
category: ".net"  
tags: ["sql server"]  
reading_time: 1 minute  

---

# SQL INNER JOIN Keyword.

how to use [inner join](https://www.mindstick.com/blog/304465/difference-between-inner-join-left-join-right-join-and-full-outer-join-in-sql-server) in [sqlserver](https://www.mindstick.com/forum/33737/between-condition-in-sqlserver) please help me .

## Replies

### Reply by Anonymous User

The INNER [JOIN](https://www.mindstick.com/articles/1487/join-sleep-and-interrupt-methods-in-c-sharp-threading) keyword selects all rows from both tables as long as there is a match between the columns in both tables.

**Syntax:**

```
SELECT column_name(s)FROM table1INNER JOIN table2ON table1.column_name=table2.column_name where table1.column_name=value;
```

```

```

```
Example:select a.CustomerID, b.CustomerName,b.ContactName,b.Address,b.City ,b.Country,a.Orderdate,a.OrderID,a.amount from Customer b inner join [Order] a on a.customerID=b.CustomerID where b.CustomerID=1
```

```

```


---

Original Source: https://www.mindstick.com/forum/33572/sql-inner-join-keyword

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