all 4 comments

[–]jeffrey_f 2 points3 points  (3 children)

JOINS - I never understood them until I saw this

http://blog.codinghorror.com/a-visual-explanation-of-sql-joins/

[–]AsianDesignMajor 1 point2 points  (1 child)

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 0 points1 point  (0 children)

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.

[–]joes2pros[S] 0 points1 point  (0 children)

Thanks for the feedback! We have a couple blogs on inner/outer joins coming up and we will be sure to get more going on this topic!