An SQL JOIN clause is used to combine rows from two or more tables, based on a common field between them.
Different SQL JOINs :
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
Showing posts with label SQL JOIN. Show all posts
Showing posts with label SQL JOIN. Show all posts
Subscribe to:
Posts (Atom)