---
title: "Equi join Vs Inner Join top differences to read today"
description: "Two kinds of Joins equi join and inner join mostly a confusion to all SQL developers. The given clear differences highly useful so that a basic learner can understand quickly."
url: https://srinimf.com/2018/01/05/equi-join-vs-inner-join-top-differences-to-read-today/
date: 2018-01-05
modified: 2026-10-10
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2018/01/equi-join-vs-inner-join.jpg?fit=1200%2C700&ssl=1
categories: ["SQL"]
tags: ["Equi join and Inner join differences", "Equi join vs Inner join in SQL", "SQl Equi Join", "SQl Inner Join", "SQL tips and tricks"]
type: post
lang: en
---

# Equi join Vs Inner Join top differences to read today

The equi [JOINs and](https://srinimf.com/2012/07/10/sql-db2-and-joins/) Inner JOINs are tricky in SQL. Many programmers think that both are same, but unable to tell where the functionally is different. So, I have selected this point to explain clearly where both differ each other.

---

## **SQL Equi JOIN**

The term equi join states [joining two are more tables](https://srinimf.com/2018/06/09/real-idea-left-outer-join-you-always-need-to-code-in-db2-read-now/) based on equal condition.

In the above example there are two tables ‘Customer mast’ and ‘Mem type mast’. The arrow mark shows that result of equi joins.

![Equi join in SQL](https://i0.wp.com/image.slidesharecdn.com/sql-joins-140921063556-phpapp02/95/sql-joins-22-638.jpg?resize=638%2C479&ssl=1)

How the **Equi joins** will Form

- The Joins are formed based on equal ‘=’ condition in ‘WHERE’ clause . I mean to say that in ‘WHERE’ clause you can give ‘>’ or ‘<‘ condition. But in equi-join scenario only *eaual condition* is given.
- The result of equi join is the the matching rows will be joined based on the equal matching columns in both (or more) tables
- Do not confuse that a join can be formed on two or more tables.
- In equi-join the join condition is usually given in ‘WHERE’ clause

**Example equi Join**

The first table is “Customermast”

[![Tab1](https://i0.wp.com/srinimf.com/wp-content/uploads/2018/01/tab1.png?resize=411%2C159&ssl=1)](https://i0.wp.com/srinimf.com/wp-content/uploads/2018/01/tab1.png?ssl=1)

The second Table is “Memtypemast”

[![Tab2](https://i0.wp.com/srinimf.com/wp-content/uploads/2018/01/tab2.png?resize=372%2C168&ssl=1)](https://i0.wp.com/srinimf.com/wp-content/uploads/2018/01/tab2.png?ssl=1)

```
SELECT DEPT, PROJ
FROM CUSTOMERMAST C, MEMTYPEMAST M
WHERE C.ROLE = M.ROLE;
```

The result of equi Join is as follows

[![Tab3](https://i0.wp.com/srinimf.com/wp-content/uploads/2018/01/tab3.png?resize=183%2C168&ssl=1)](https://i0.wp.com/srinimf.com/wp-content/uploads/2018/01/tab3.png?ssl=1)

## **SQL Inner Join**

The term inner join means only matching rows in the first table are included. There is no concept of ‘LEFT INNER JOIN’ or ‘RIGHT INNER JOIN’

Related[7 Exclusive Ideas to Enhance DB2 Performance](https://srinimf.com/2023/10/05/db2-sql-performance/)

![Inner Join in SQL](https://i0.wp.com/srinimf.com/wp-content/uploads/2018/01/8947f-1464122780890.png?resize=450%2C350&ssl=1)

**Inner Join**

- In inner join, only matching rows of first table (TABLE A),  will be formed in the result
- SQL query first it looks for each matching row of TABLE-A in TABLE-B. If matching rows present, those rows formed into result table
- You can give in inner join any condition like ‘=’,'<‘ and ‘>’. Here, it differentiates with equi Join.
- The above SQL query is also applicable for Inner join.

Related Posts

- [How to Join 3 Tables—Without Join Keyword](https://srinimf.com/2021/04/24/how-to-sql-query-to-join-three-tables/)DateApril 24, 2021
- [Different Types of Joins in Pandas: A Comprehensive Guide](https://srinimf.com/2024/09/15/different-types-of-joins-in-pandas-a-comprehensive-guide/)DateSeptember 15, 2024
- [SQL JOIN Example: Using Vs. ON This is the Difference](https://srinimf.com/2020/01/29/sqlquery-joins-how-to-write-with-using/)DateJanuary 29, 2020

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2018%2F01%2F05%2Fequi-join-vs-inner-join-top-differences-to-read-today%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2018%2F01%2Fequi-join-vs-inner-join.jpg%3Ffit%3D1200%252C700%26ssl%3D1&description=Equi%20join%20Vs%20Inner%20Join%20top%20differences%20to%20read%20today)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2018/01/05/equi-join-vs-inner-join-top-differences-to-read-today/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2018/01/05/equi-join-vs-inner-join-top-differences-to-read-today/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2018/01/05/equi-join-vs-inner-join-top-differences-to-read-today/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2018/01/05/equi-join-vs-inner-join-top-differences-to-read-today/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20Equi%20join%20Vs%20Inner%20Join%20top%20differences%20to%20read%20today&body=https%3A%2F%2Fsrinimf.com%2F2018%2F01%2F05%2Fequi-join-vs-inner-join-top-differences-to-read-today%2F&share=email)
-

### Like this:

Like Loading…