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

A. It must have primary-key and foreign-key constraints defined on the columns used in the join condition.

B. It requires the column names to be the same in all tables used for the join conditions.

C. It is applicable for equijoin and nonequijoin conditions.

D. It is applicable for only equijoin conditions.