Good refresher.

Our company policy is to NOT use table aliases.  The VP in charge of development came down hard.  You have to use them in self joins though.