Basically Joins are used to get result from two or more
tables and there are two types of joins  
inner join and outer join  
Inner join : a join of two or more tables which omits the
blank rows while checking 
 
Outer join is subcatogorised in to left outer join and right
outer join. Which includes blank rows in specifed side if
condition satisfies.  
Simple outer join is combination of left and right outerjoins. 
Apart from these there are  
Natural join : cartisian product 
Equi join : which includes = operator in condition 
NonEqui join : All conditional joins which doesn't uses = in
there conditions.

The SQL join command is used to join two or more tables. At 
times you may need to join two or more tables to retrieve 
the information you need from your SQL database

Types Of Joins-
1.Inner Join
2.Outer Join -types -
left Outer,
Right Outer,
Full Join

3.Cross Join
4.Self Join

16)Join
Table1:Record
1	a
2	b
3	b
4	b
4	c
Table2:Record1
1	a	2
2	b	2
3	c	24
5	f	2
8	g	2
10	j	NULL
Inner Join:
Qry1:select record_name,recordcount from record inner join 
record1 on 
record.record_id=record1.record_code
Result:
a	2
b	2
b	24
qry2:select p.record_name,q.recordcount from  record p, 
record1 q where p.record_id=q.record_code
Result:
a	2
b	2
b	24
Left Join
qry3:select record_name,recordcount from record left join 
record1 on 
record.record_id=record1.record_code
Result:
a	2
b	2
b	24
b	NULL
c	NULL
Right Join
qry4:select record_name,recordcount from record right join 
record1 on 
record.record_id=record1.record_code
Result:
a	2
b	2
b	24
NULL	2
NULL	2
NULL	NULL
Left Outer Join
qry5:select record_name,recordcount from record left outer 
join record1 on 
record.record_id=record1.record_code
Result:
a	2
b	2
b	24
b	NULL
c	NULL
Right Outer Join
qry6:select record_name,recordcount from record right outer 
join record1 on 
record.record_id=record1.record_code
Result:
a	2
b	2
b	24
NULL	2
NULL	2
NULL	NULL
Full Outer Join
qry7:select record_name,recordcount from record full outer 
join record1 on 
record.record_id=record1.record_code
Result:
a	2
b	2
b	24
b	NULL
c	NULL
NULL	2
NULL	2
NULL	NULL

"Their is No Left Inner Join,Right Inner Join in SQL Server