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; }