Inner join question is incorrect!

Question

The inner join question in the sample is incorrect and didn't use inner join at all

Answer 1

The inner join question does join the tables - in the where clause.

Joining tables in the where-clause is a old school way of joining tables, however with the join-clause theres the benefit of separation of concerns.

Its good that it shows that theres more than one way of accomplishing the same thing but bad that it doesnt clarify it, especially since the lecture is about the syntax rather than the result.

Answer 2

Actually you mentioned the point

Answer 3

yea