Pages

Ads 468x60px

Inner Join Example with Images

First Create Emp Table

create table Emp(E_Id int, E_Name varchar(30),E_Salary int)

Insert into Emp values(1,'Vikas',14000);




Create Department Table

create table Emp_Department(EmpId int primary key,DName varchar(20));

insert into Emp_Department values(1,'web Development');

Inner Join Example

select a.E_Name as Employee_Name,b.DName as

Department_Name from Emp a inner join

Emp_department b on a.E_id=b.Empid

Is same as

select a.E_Name as Employee_Name,b.DName as

Department_Name from Emp a join

Emp_department b on a.E_id=b.Empid


No comments:

Post a Comment