Remove AS from table aliases.

Having AS causes issues with Oracle. While this is not a core driver,
the AS keyword is not required by any supported driver.

Refs #4830
Attempt to fix up tests on SQLserver.
Merge pull request #4835 from cakephp/issue-4830

Remove AS from table aliases.