Which of the following is the basic approaches for joining tables?

Category: SQLWhich of the following is the basic approaches for joining tables?
Editor">Editor Staff asked 2 years ago

Which of the following is the basic approaches for joining tables?

  1. Union JOIN
  2. Natural JOIN
  3. Subqueries
  4. All of the above
1 Answers
Editor">Editor Staff answered 2 years ago

Answer:
4. All of the above
Explanation:
We already know that Union and Natural are the approaches for joining two or more tables.
A subquery is a query nested into another SQL query. It can be embedded with SELECT, INSERT, UPDATE or DELETE statement. A subquery is known as the inner query. In many cases, we can use the subquery instead of a JOIN. Therefore, option D is the correct choice.