Data Exchange between Azure Sql Server Managed Instance to Azure Sql Server

Hi Guru's

 My ask is that we want to migrate only some selected entities and associated attributes from a database hosted on Azure SQL Server Managed Instance to Azure SQL Server.

Can we create a Linked Server on Azure SQL Server and then use Select Into Statement to create tables with the required column names and condition.

SELECT customer_id, first_name, last_name, email

INTO TargetDB.dbo.customers

FROM linked_server.SRC_DB.sales.customers

WHERE state = 'CA';

 Here Target DB is the Database on Azure Sql and SRC_DB is Azure Sql Server Managed Instance.

If not then what would be an alternative solution to meet this requirement?

Regards

Anu