---

Equi Join (Inner Join)

---

In this join where the rows and column are matching or values are matching only those will be display as output. In this join we need to equal to operator in the where clause of select string.

Suppose we have two tables table1 and table2 in our database the we apply Equi join or Inner join in both table

These are two tables

Table1

Table2

These are two methods to join these two table

Syntax:

   select * from table1 table2 where table1.dept_name=table2.dept_name;

select table1.emp_id,table1.emp_name,table1.salary,table2.adress from table1 inner join table2 using(dept_name);

select * from table1 inner join table2 using(dept_name);

---