How to join same table?

Question

Zend Framework

Statement could not be executed (42000 - 1066 - Not unique table/alias: 'media')

$select->join(
            DbTables::TBL_MEDIA,
            DbTables::TBL_MEDIA . '.id = ' . $this->getTable() . '.media',
            [
                'logo_path' => 'media_path'
            ],
            Select::JOIN_LEFT
        );

        $select->join(
            DbTables::TBL_MEDIA,
            DbTables::TBL_MEDIA . '.id = ' . DbTables::TBL_REL_ANNOUNCEMENT_MEDIA . '.media_id',
            [
                'announcement_media_path' => 'media_path'
            ],
            Select::JOIN_LEFT
        );

Answer 1

Specify different aliases
, eg m1 and m2