Online Tutorials & Training Materials | STechies.com
Register Login

What is true about joining tables through an equijoin?

Shalesh Singh Visen || 02 Mar 2008 5:33 am || 1

Q. What is true about joining tables through an equijoin?

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.

Answer: E


Comments

  • 01 Jun 2009 8:59 am
    This answer is right.Because to join two tables through an equijoin, the columns in the join condition must not primary key and foreign key columns.