JOINS IN SQL SERVER
I am going to explain various type of join in SQL server like Inner Join ,cross join , Left Outer Join, Right Outer Join, Full Outer Join, Equi Join ,Hash Join.
Before going to join discussion first I am going to create two table . One is Employee another one is Location.
|EmpId||First Name||Last Name||DOJ||Location ID|
- INNER Join :-
The join that display only those record that have a match in both joined table is known as inner join. This is default join.
FROM table1 a1
INNER JOIN table2 a2
select A.FirstName,L.Street from Employee as A
inner join Location L