Inner Join in DBMS

Inner join Definition

• Tables are joined based on equality condition
• Only matching records are displayed
• Joining tables must have at least one common same data type and the same values.

Syntax

select col1,col2,col3.... 
from table1,table2
where table1.common col name = table2.common col name;

Example for Inner Join

Consider two tables emp and dept with the following data

Emp table

Dept table

Write SQL Query to display data from two tables emp and dept wherever there is common dept no and from the sales department

select
rownum,Empno,Ename,Emp.Deptno,Dname, sal*12 annsal,loc
from Emp,Dept
where Emp.Deptno=Dept.deptno and dname='SALES';

O/P

We are having 6 rows in emp table from the sales department, with dept no=30 and matches with deptno=30 which is appended with the data in dept table as a result total of 6 rows are displayed