Search the Whole World Here.,.,

Different SQL JOINs

Different SQL JOINs





Before we continue with examples, we will list the types of the different SQL JOINs you can use:
  • INNER JOIN: Returns all rows when there is at least one match in BOTH tables.
  • LEFT JOIN: Return all rows from the left table, and the matched rows from the right table.
  • RIGHT JOIN: Return all rows from the right table, and the matched rows from the left table.
  • FULL JOIN: Return all rows when there is a match in ONE of the tables.

Related Posts


EmoticonEmoticon

:)
:(
=(
^_^
:D
=D
=)D
|o|
@@,
;)
:-bd
:-d
:p
:ng
:lv
Subscribe to: Post Comments (Atom)