Web Administration > Databases

joins in Database

<< < (3/3)

Brackwom:
SQL specifies five types of JOIN : INNER , LEFT OUTER , RIGHT OUTER , FULL OUTER and CROSS. if we can join two tables that will reduce the number of rows needed to be processed by subsequent steps, then our performance will improve.

jackharry11:
There are different types of joins like inner join, outer join, self join

dark404:

--- Quote from: sourabhsharma.obizm on 07-19-2012, 14:17:12 ---There are different types of joins like inner join, outer join, self join, cross join, natural join, equi join, non-equi join.
 :D

--- End quote ---
Can you explain it to me in detail.

dark404:
Join-returns both the tables if their is atleast one match in database of two tabels
Left Join-returns all the left table data even if their is no match with right table
Right Join-returns all the  right table rows only ,even when their is no match in left table rows
Full Join-returns a row when their is match in one table

f1dark:
There are different types of joins like inner join, outer join, self join,

Navigation

[0] Message Index

[*] Previous page

Go to full version