Answer:
mainly used to combine two tables based on a specified common field between them. If we talk in terms of Relational algebra, it is the cartesian product of two tables followed by the selection operation. Thus, we can execute the product and selection process on two tables using a single join statement. We can use either 'on' or 'using' clause in MySQL to apply predicates to the join queries.
A Join can be broadly divided into two types:
Inner Join
Outer Join
Inner Join is a join that can be used to return all the values that have matching values in both the tables. Inner Join can be depicted using the below diagram.
The inner join can be further divided into the following types:
Equi Join
Natural Join
Now let us learn about these inner joins one-by-one.
In this exercise we have to know the join definitions to explain each type, like:
The most common are Inner join and Outer Join.
We can first deal with the inner join, which is:
The outer join can be defined as:
See more about programming at brainly.com/question/11288081
