Create Table Employee
(
	EmpId		int,
	EmpName		Varchar(50),
	DepId		int
)

Insert into Employee(EmpId,EmpName,DepId) Values (1,'kannu',1)
Insert into Employee(EmpId,EmpName,DepId) Values (2,'Ram',1)
Insert into Employee(EmpId,EmpName,DepId) Values (3,'Kumar',2)
Insert into Employee(EmpId,EmpName,DepId) Values (4,'Murali',3)
Insert into Employee(EmpId,EmpName,DepId) Values (5,'Ranjith',4)
Insert into Employee(EmpId,EmpName,DepId) Values (6,'Suresh',4)
Insert into Employee(EmpId,EmpName,DepId) Values (7,'Selva',5)
Insert into Employee(EmpId,EmpName,DepId) Values (8,'Muthu',6)


Select * from Employee


Create Table Department
(
	DeptId		int,
	DeptName	Varchar(50)

)

Insert into Department(DeptId,DeptName) Values (1,'Account')
Insert into Department(DeptId,DeptName) Values (2,'Testing')
Insert into Department(DeptId,DeptName) Values (3,'Web Develop')
Insert into Department(DeptId,DeptName) Values (5,'PDA Develop')
Insert into Department(DeptId,DeptName) Values (6,'Java')
Insert into Department(DeptId,DeptName) Values (7,'DBA')

Select * from Employee
Select * from Department


Inner Join

Select A.*,B.* from Employee A Inner Join Department B on A.DepId=B.DeptId

Outer Join

Select A.*,B.* from Employee A Left Outer Join Department B on A.DepId=B.DeptId

Select A.*,B.* from Employee A Right Outer Join Department B on A.DepId=B.DeptId

Cross Join

Select A.*,B.* from Employee A Cross Join Department B