Follow Me : https://www.youtube.com/c/SauravAgarwal
12.What are the different types of Joins?
○ INNER JOIN: Gets all the matching records from both the left and right tables based on joining
columns.
○ LEFT OUTER JOIN: Gets all non-matching records from left table & AND one copy of matching
records from both the tables based on the joining columns.
○ RIGHT OUTER JOIN: Gets all non-matching records from right table & AND one copy of
matching records from both the tables based on the joining columns.
○ FULL OUTER JOIN: Gets all non-matching records from left table & all non-matching records
from right table & one copy of matching records from both the tables.
○ CROSS JOIN: returns the Cartesian product.
13. What are the different types of Restricted Joins?
○ SELF JOIN: joining a table to itself
○ RESTRICTED LEFT OUTER JOIN: gets all non-matching records from
left side
○ RESTRICTED RIGHT OUTER JOIN - gets all non-matching records from
right side
○ RESTRICTED FULL OUTER JOIN - gets all non-matching records from left table & gets all non-
matching records from right table.
Do'stlaringiz bilan baham: