I should always alias tables in queries, even if I'm not joining anything. It just makes life that much easier when I need to come through later and add a join (or 10), and not adding a new alias to XX places (yeah, I over use subselects sometimes).