A good article for beginners.

Actually, many people do not know that 'JOIN' clauses work this way (they know that JOINs work, but they don't know exactly how).

I will be showing...