In order to perform an inner join, which criteria must be true?A. The common columns in the join do not need to have shared values.B. The tables in the join need to have common columns.C. The common columns in the join may or may not have shared values.D. The common columns in the join must have shared values.

  • Interview Candidate
  • 8
  • 9298

Showing Answers 1 - 8 of 8 Answers

DhruvDBA

  • Jul 28th, 2006
 

C:. the answer is c because the need to have common columns in join arise in case of NATURAL JOIN not in equi or inner join.

  Was this answer useful?  Yes

acey

  • Nov 7th, 2006
 

A and C. it doesn't matter if the columns have different names, as long as the datatypes can be matched. actually even if A wasn't true you still can do a inner join by using conversion functions in one side or the other.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions