What are Joins

Question

Hi!!

Can someone tell me what Joins are?

Answer 1

JOINS are used to combine rows from two or more tables, based on a related column between those tables. The following are the types of joins: 

• INNER JOIN: This join returns those records which have matching values in both the tables.
• FULL JOIN: This join returns all those records which either have a match in the left or the right table.
• LEFT JOIN: This join returns records from the left table, and also those records which satisfy the condition from the right table.
• RIGHT JOIN: This join returns records from the right table, and also those records which satisfy the condition from the left table.