Joins

Question 1

What is a Join

Answer 1

A JOIN clause is used to combine rows from two or more tables, based on a related column between them. It is used to merge two tables or retrieve data from there.

Question 2

Inner Join

Answer 2

the most common type of join. It is used to return all the rows from multiple tables where the join condition is satisfied.

Question 3

Full/Outer Join

Answer 3

returns all the records when there is a match in any of the tables. Therefore, it returns all the rows from the left-hand side table and all the rows from the right-hand side table.

Question 4

Left Join

Answer 4

used to return all the rows from the left table but only the matching rows from the right table where the join condition is fulfilled.

Question 5

Right Join

Answer 5

used to return all the rows from the right table but only the matching rows from the left table where the join condition is fulfilled.

Question 6

How many types of Joins?

Answer 6

4: Inner, Full/Outer, Left, Right

Question 7

Interactive Join Practice

Answer 7

https://learnsql.com/course/joins