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.


EmoticonEmoticon

Subscribe to: Post Comments (Atom)