Inner Join,Left Join, Right Join and Create View

*Inner Join

select E.empid,E.empname,E.address,E.phno,E.salary,E.deptname,E.deptid from employee E inner join emp1 B ON E.DeptID=B.DeptID

*Inner Join

select E.empid,E.empname,E.address,E.phno,E.salary,E.deptname,E.deptid from employee E inner join employee1 B ON B.DeptName=E.DeptName

*Inner Join

select E.empid,E.empname,E.address,E.phno,E.salary,E.deptname,E.deptid from employee E inner join employee1 B ON B.EmpID=E.EmpID

*Inner Join

select E.empid,E.empname,E.address,E.phno,E.salary,E.deptname,E.deptid from employee E inner join employee1 B ON B.EmpID=E.EmpID where B.deptid=20

*Inner Join

select E.empid,E.empname,E.address,E.phno,E.salary,E.deptname,E.deptid from employee E inner join employee1 B ON B.EmpID=E.EmpID where E.deptid=20

*Inner Join

select E.empid,E.empname,E.address,E.phno,E.salary,E.deptname,E.deptid from employee E inner join employee1 B ON B.EmpID=E.EmpID where E.DeptName='B.Tech'

*Inner Join

select E.empid,E.empname,E.address,E.phno,E.salary,E.deptname,E.deptid from employee E inner join employee1 B ON B.EmpID=E.EmpID where E.DeptName='MBA'

*Inner Join

select E.empid,E.empname,E.address,E.phno,E.salary,E.deptname,E.deptid from employee E inner join employee1 B ON B.EmpID=E.EmpID where E.DeptName='M.Tech'

*Left Join

select E.empname,E.address,E.salary,B.deptname,B.deptid from employee E left join employee1 B ON E.EmpID=B.EmpID

*Left Bita Join

select E.empname,E.address,E.salary,B.deptname,B.deptid from employee E,employee1 B where E.empid=B.empid

*Right Join

select E.empname,E.address,E.salary,B.deptname,B.deptid from employee1 B right join employee E ON B.empid=E.empid

*Right Bita Join

select E.empname,E.address,E.salary,B.deptname,B.deptid from employee1 B,employee E where B.empid=E.empid

*Right Bita Join

select Emp.empname as "EmpName",Dept.deptname as "DeptName" from employee Emp,employee Dept where Emp.empid=Dept.empid

//select Emp.empname as "EmpName",Dept.deptname as "DeptName" from employee Emp self join employee Dept ON Emp.empid=Dept.empid

https://www.youtube.com/channel/UCKLRUr6U5OFeu7FLOpQ-FSw/videos