SQL: Join(Different types of joins with examples) part 2
Create table Studenttable(S_Id Int,Mobile int,Address Varchar(20),City char(10))
Insert into Studenttable values(1,123456,'Address11','Hyderabad'),
(2,234567,'Address25','Mumbai'),
(3,345678,'Address33','Chennai'),
(4,456789,'Address58','Pune'),
(5,569874,'Address63','Jaipur'),
(6,693258,'Address45','Bhopal')
Create table Detailtable(Id int,Name varchar(20),Gender char(10))
insert into Detailtable values(1,'Ramesh','Male'),
(2,'Laxmi','Female'),(3,'Laxman','Male'),
(4,'Rajesh','Male'),(5,'Mohan','Male')
select * from Studenttable
select * from Detailtable
-------------------------------------
-Inner Join --------
select s.S_Id,d.Name,s.Mobile,s.Address from Studenttable s
inner join Detailtable d
on s.S_Id=d.Id
------------------------------------------
--left Join
select s.S_Id,d.Name,s.Mobile,s.Address from Studenttable s
left outer join Detailtable d
on s.S_Id=d.Id
------------------------------------------
-Right Join ---
select s.S_Id,d.Name,s.Mobile,s.Address from Studenttable s
right outer join Detailtable d
on s.S_Id=d.Id
--------------------------------------
-Full Join----
select s.S_Id,d.Name,s.Mobile,s.Address from Studenttable s
full outer join Detailtable d
on s.S_Id=d.Id
-------------------------------------------------
-Cross Join or Cartesian---
select s.S_Id,d.Name,s.Mobile,s.Address from Studenttable s
cross join Detailtable d