Which statement is true about an inner join specified in the WHERE clause of a query?

Question

Options

• AIt must have primary-key and foreign key constraints defined on the columns used in the join
• BIt requires the column names to be the same in all tables used for the join conditions.
• CIt is applicable for equijoin and nonequijoin conditions.
• DIt is applicable for only equijoin conditions.

• A
  4% (1)
• B
  4% (1)
• C
  85% (22)
• D
  8% (2)

No community discussion yet for this question.