Statement execution spans several databases

What should I do if I want to operate different tables in different databases on different servers in one statement?
Method 1:

Select * From OpenDataSource ('sqlodb', 'Data source = remote IP address; user id = sa; Password = password'). Database Name. DBO. Table Name
Method 2:
Use the connection server first:

Exec sp_addmediaserver 'Alias ', '', 'msdasql', null, null, 'driver = {SQL Server}; server = remote name; uid = user; Pwd = password ;'
Exec sp_add1_srvlogin @ rmtsrvname = 'aliased ', @ useself = 'false', @ locallogin = 'sa', @ rmtuser = 'sa ', @ rmtpassword = 'Password'
Go
Then you can:
Select * from alias. Database Name. DBO. Table Name
Insert database name. DBO. Table Name select * from alias. Database Name. DBO. Table Name
Select * into database name. DBO. New table name from alias. Database Name. DBO. Table Name
Go