What is true about joining tables through an equijoin? - ProProfs Discuss
Topics-
Products +
     

What is true about joining tables through an equijoin?

What is true about joining tables through an equijoin?

Change Image    Delete



A. You can join a maximum of two tables through an equijoin.
B. You can join a maximum of two columns through an equijoin.
C. You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.
D. . To join two tables through an equijoin, the columns in the join condition Must be primary key and foreign key columns
E. You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions

This question is part of Oracle_Test7
Asked by Sudha_test, Last updated: Jul 20, 2018

+ AnswerRequest Answer
...

2 Answers

M. Krasinski

M. KrasinskiContent Writer, Columbus
Content Writer, Columbus

Answered on Jul 20, 2018

The answer to this question is E. You can join n tables (all having single column primary keys) in an SQL statement by specifying a minimum of n-1 join conditions. The columns in the join condition should coincide with each other. If in case there are some differences, then there may be issues in joining the columns together.

If you want to perform EQUI JOIN, you can also use the keyword JOIN then follow that with ON so that the columns that you have chosen will be checked if they are equal with each other. If they are found to be equal, then they would be matched and mixed well.

 Reply

John Smith

John Smith

Answered on Mar 10, 2017

You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.
You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions
 Reply

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.