Skip to main content

Return to Answer

Highlighted and Capitilized the key words
Source Link
edit approved Sep 26, 2013 at 21:25
A_Pointar
edit approved Sep 26, 2013 at 21:25
A_Pointar
  • 131
  • 1
  • 13

Inner joinINNER JOIN requires there is at least a match in comparing the two tables. For example, table A and table B which implies A ٨ B (A intersection B).

Left outer joinLEFT OUTER JOIN and left joinLEFT JOIN are the same. It gives all the records matching in both tables and all possibilities of the left table.

Similarly, right outer joinRIGHT OUTER JOIN and right joinRIGHT JOIN are the same. It gives all the records matching in both tables and all possibilities of the right table.

Full joinFULL JOIN is the combination of left outer joinLEFT OUTER JOIN and right outer joinRIGHT OUTER JOIN without duplication.

Inner join requires there is at least a match in comparing the two tables. For example, table A and table B which implies A ٨ B (A intersection B).

Left outer join and left join are the same. It gives all the records matching in both tables and all possibilities of the left table.

Similarly, right outer join and right join are the same. It gives all the records matching in both tables and all possibilities of the right table.

Full join is the combination of left outer join and right outer join without duplication.

INNER JOIN requires there is at least a match in comparing the two tables. For example, table A and table B which implies A ٨ B (A intersection B).

LEFT OUTER JOIN and LEFT JOIN are the same. It gives all the records matching in both tables and all possibilities of the left table.

Similarly, RIGHT OUTER JOIN and RIGHT JOIN are the same. It gives all the records matching in both tables and all possibilities of the right table.

FULL JOIN is the combination of LEFT OUTER JOIN and RIGHT OUTER JOIN without duplication.

added 32 characters in body
Source Link
Peter Mortensen
Peter Mortensen
  • 31.4k
  • 22
  • 110
  • 134

Inner join requires there is atleastat least a match in comparing the two tables. For example, table A and table B. which implies A ٨ B  (A intersection B).

Left outer join and left join are the same. It It gives all the records matchmatching in both tables and all posibilitiespossibilities of the left table.

similarlySimilarly, Right right outer join and right join are the same. It It gives all the records matchmatching in both tables and all posibilitiespossibilities of the right table.

Full join is the combination of left outer join and right outer join without duplication.

Inner join requires there is atleast match in comparing two tables. For example table A and table B. which implies A ٨ B(A intersection B)

Left outer join and left join are same. It gives all the records match in both tables and all posibilities of left table.

similarly, Right outer join and right join are same. It gives all the records match in both tables and all posibilities of right table.

Full join is the combination of left outer join and right outer join without duplication.

Inner join requires there is at least a match in comparing the two tables. For example, table A and table B which implies A ٨ B  (A intersection B).

Left outer join and left join are the same. It gives all the records matching in both tables and all possibilities of the left table.

Similarly, right outer join and right join are the same. It gives all the records matching in both tables and all possibilities of the right table.

Full join is the combination of left outer join and right outer join without duplication.

Source Link
naga
naga
  • 717
  • 5
  • 2

Inner join requires there is atleast match in comparing two tables. For example table A and table B. which implies A ٨ B(A intersection B)

Left outer join and left join are same. It gives all the records match in both tables and all posibilities of left table.

similarly, Right outer join and right join are same. It gives all the records match in both tables and all posibilities of right table.

Full join is the combination of left outer join and right outer join without duplication.