Respuesta :

angellmadhwani

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.

lhmarianateixeira

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:

  • Inner joins combine records from two tables whenever there are matching values in common to both tables. For exemple, can be used to select a result intersect in a Venn diagram.

The outer join can be defined as:

  • Outer join combine records from two tables whenever there are matching values in common but will return every row from one specified table, even if the join condition fails.

See more about programming at brainly.com/question/11288081