public function testLeftJoin()
{
$args = new ArgumentArray();
$driver = new MySQLDriver();
$query = new SelectQuery();
$query->select(array('id', 'name', 'phone', 'address'))->from('users', 'u');
$query->leftJoin('posts')->as('p')->on('p.user_id = u.id');
$sql = $query->toSql($driver, $args);
$this->assertEquals('SELECT id, name, phone, address FROM users AS u LEFT JOIN posts AS p ON (p.user_id = u.id)', $sql);
return $query;
}
