Register now or log in to join your professional community.
Different Joins are
1.Left Join
Returns all rows form the left table, even if there are no matches in the right table.
2.Inner Join
Inner join returns records at the intersection of the two tables.
3.Right Join
Right join is a mirror version of the left join and allows to get a list of all orders, appended with customer information
4. Full Join
list of all records from both tables
3.
SQL Join Types:
INNER JOIN: returns rows when there is a match in both tables.
LEFT JOIN: returns all rows from the left table, even if there are no matches in the right table.
RIGHT JOIN: returns all rows from the right table, even if there are no matches in the left table.
FULL JOIN: returns rows when there is a match in one of the tables.
SELF JOIN: is used to join a table to itself as if the table were two tables, temporarily renaming at least one table in the SQL statement.
CARTESIAN JOIN: returns the Cartesian product of the sets of records from the two or more joined tables.
there are three types of joints
1) Inner join
2)Left outer join
3)Right outer join
