I need to join Two data tables there are in two different server.
Are there any SQL query to do that?
I know if Two data tables are in single server, I can easily use below SQL query to
“Insert into [UiPath_Dev].[dbo].[VendorInventory_Onsale_JoinResult]
from [UiPath_Dev].[dbo].[VendorInventory_Onsale_Main] as t1
left join [BODS_Prod].[dbo].[MaterialStatus] as t2 on t1.ArticleNumber=t2.RSArticleNumber”
But my problem Two data tables there are in two different server.