Author Question: Discuss the differences between an equi-join, natural join and outer join. What will be an ideal ... (Read 145 times)

Evvie72 · **on:** Jul 7, 2018

Discuss the differences between an equi-join, natural join and outer join.

What will be an ideal response?

Question 2

Restrictions on removable media should be enforced by relying on user behavior, rather than technological restrictions.

Indicate whether the statement is true or false.

spencer.martell · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

Both a natural join and an equi-join create a join based upon equality between some common columns. While the equi-join keeps the redundant columns that are used for the match, the natural join removes duplicates. There are situations where one table may contain information that is not in the other table. However, it is necessary to display both matching data as well as records which do not have a match in the second table. This situation is where we would use an outer join.

Answer to Question 2

Answer: FALSE