Self Join and full outer join with example

Query for Self Join Table will be joined by itself, first we will give two different name of a table after that i will join these two table by inner join.
Syntax :

Select Column_Name1,Column_Name2
from Table1 as A
Inner join Table2 as B
On A.column_name = B.column_name

consider the following table : Salary:

Emp_id	Emp_salary	Emp_desig
01	25000	Software Eng
02	30000	Senior Software Eng
03	25000	Software Analyst

Query of self join:

select *
from salary as a
inner join salary as b
on a.Emp_id = b.Emp_id

Result :

Emp_id	Emp_salary	Emp_desig	Emp_id	Emp_salary	Emp_desig
01	25000	Software Eng	01	25000	Software Eng
02	30000	Senior Software Eng	02	30000	Senior Software Eng
03	25000	Software Analyst	03	25000	Software Analyst

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Query for Full Outer Join It is the combination of left join and right join means all the reocrds from both the table will appear.
Syntax :

Select Column_Name1,Column_Name2
from Table1
Full outer join Table2
On Table1.column_name = Table2.column_name

consider the following table : Salary:

Emp_id	Emp_salary	Emp_desig
01	25000	Software Eng
02	30000	Senior Software Eng
03	25000	Software Analyst
05	35000	Software lead

Employee_detail:

Emp_id	Emp_city	Emp_gender
01	Pune	Male
02	Delhi	Female
03	Noida	Male
04	Gurgaon	Female

Query of self join:

select *
from salary as a
inner join salary as b
on a.Emp_id = b.Emp_id

Result :

Emp_id	Emp_salary	Emp_desig	Emp_id	Emp_city	Emp_gender
01	25000	Software Eng	01	Pune	Male
02	30000	Senior Software Eng	02	Delhi	Female
03	25000	Software Analyst	03	Noida	Male
Null	Null	Null	04	Gurgaon	Female
05	35000	Software lead	Null	Null	Null

Tag:Outer Join with example, Self join with example