almost 6 years ago
Joins are used to combine the data from two tables and return specific rows of data from the tables.
A join can be either an inner join or an outer join, depending on what is expected in the result.
Gets all matching rows in BOTH tables
Gets all rows from the left table along with matching rows from the right table
Gets all rows from the right table along with matching rows from the left table
Gets all rows provided there is a match in ONE of the tables
Let us say we have table X with data as below:
Let us say we have table Y with data as below:
Following will be the result of INNER JOIN :
Following will be the result of LEFT OUTER JOIN :
Following will be the result of RIGHT OUTER JOIN :
Following will be the result of FULL OUTER JOIN :
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
Terms of Service
| © copyright 2021 FindNerd.com. All rights reserved.
Sign up using