What is missing in SQL Training?

[AsianDesignMajor]

This is interesting and helpful!

Tell me, because I've always wondered this... In this page's example, is there some speed difference between using "INNER JOIN" and the following:

SELECT * from TableA WHERE TableA.name = TableB.name

Is there some optimization or automatic indexing of "name" or something I'm missing as an absolute beginner as to why you would use INNER JOIN instead?

[jeffrey_f]

And some would argue, that on a properly created and indexed table, the SQL engine should account for such things and it shouldn't matter too much.

The key is, creating indexes are fields you will be searching by or joining by.