Joins
in Sql Server
Table
1:
Table
2
Inner
Join :-
The
INNER JOIN keyword selects all rows from both tables as long as there is a
match between the columns in both tables.
select
* from emp1
JOIN
emp2
on emp1.eid=emp2.eid
Left Outer Join:-
The LEFT
JOIN keyword returns all rows from the left table (table1), with the matching
rows in the right table (table2). The result is NULL in the right side when
there is no match.
Query for Left Outer Join:-
select
* from emp1
left
outer join
emp2
on emp1.eid=emp2.eid
Right Outer Join:-
The RIGHT
JOIN keyword returns all rows from the right table (table2), with the matching
rows in the left table (table1). The result is NULL in the left side when there
is no match.
Query for Right Outer Join:-
SQL FULL OUTER JOIN
The
FULL OUTER JOIN keyword returns all rows from the left table (table1) and from
the right table (table2).
The
FULL OUTER JOIN keyword combines the result of both LEFT and RIGHT joins.
Query for FULL OUTER JOIN :-
select
* from emp1
FULL
OUTER JOIN
emp2
on emp1.eid=emp2.eid
Cross join:-
SQL CROSS JOIN will return all records where each row from the
first table is combined with each row from the second table. Which also mean CROSS JOIN returns the Cartesian product of the sets of
rows from the joined tables.
SELECT * FROM
emp1 CROSS JOIN
emp2
Write a query to display from
table1 and table2 records?
Table 1
Table2
Sql query to join two tables are:-
select
emp1.eid,emp1.ename,emp1.esal,emp2.eadd,emp2.ephone from emp1 join emp2 on
emp1.eid=emp2.eid
