/**
* @group subquery
* @covers Query::getTable
*/
function testAddJoinWithAlias()
{
$q = new Query('table');
$q->addJoin('testing AS alias', 'alias.column = table.column');
foreach ($q->getJoins() as $join) {
$this->assertEquals('testing', $join->getTable());
$this->assertEquals('alias', $join->getAlias());
break;
}
$this->assertEquals("SELECT `table`.*\nFROM `table`\n\tJOIN `testing` AS alias ON (alias.column = table.column)", (string) $q->getQuery());
}
