Speed up JOINS in SQL

If you want to speed up JOINS include a WHERE clause after the joins, else, joins take too long to execute.