joins in Database

Started by SeoDezin, 05-09-2011, 03:49:00

Previous topic - Next topic

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
newbielink:https://hexondigital.ca/digital-branding-services-vancouver/ [nonactive]
  •  


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
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,


dark404

Quote from: Vinil on 08-16-2011, 04:01:09
Following are types of SQL joins:-
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
!-!
really wn informative post  !-!