zendframework/zf2 — pull request #1012 by bjyoungblood (2012-04-05 00:22:15+00:00)
Title: Zend\Db\Sql\Select::join now respects column aliases

Allows column aliases for joined tables in Zend\Db\Sql\Select in the same way that Select::columns does.

Example:
```$select = new Select;
$select->from('foo')->join('zac', 'm = n', array('BAR' => 'bar', 'BAZ' => 'baz'));
```
Becomes
```SELECT "foo".*, "zac"."bar" AS "BAR", "zac"."baz" AS "BAZ"
FROM "foo" INNER JOIN "zac" ON "m" = "n"```