Transfer products from website to another

Hello!
I want to transfer products from website to another in Multistore Website
Anyone has an idea?

SET FOREIGN_KEY_CHECKS=0;
UPDATE catalog_product_website
    INNER JOIN catalog_product_entity ON catalog_product_website.product_id=catalog_product_entity.entity_id
SET catalog_product_website.website_id = 2
    WHERE catalog_product_entity.smp='999999999' and catalog_product_website.website_id='1';
SET FOREIGN_KEY_CHECKS=1;

Thanks in advance

Are both websites using Magento 2?

I am using Magento 1 , Magento 1.9 exactly
It is multistore website

I think there are extensions for this.

keep in mind that I have only access to use SQL

Do you know how many extensions are being used?

Please I need SQL query , this is my problem