Join 2 tables on 2 different servers

the 2 servers are linked but I am getting an error when trying to run. Msg 208, Level 16, State 1, Line 1 Invalid object name 'COI_port.Mess.agent_data'.

SELECT datepart(Hour,Chat) as Interval, Chat ,msg.RepRegion ,msg.AgentRole ,msg.Person ,msg.Chat ,msg.ChatStart ,ChatEnd --columns needed ,[AgentMessages] ,[ConsumerMessages] ,[ResolutionHrs] ,[FirstRespSecs] ,[Abandoned] --get interval online time ,away.ntlogin ,away.report_dt ,away.int_interval ,away.backsoonsecs ,away.awaysecs
,away.onlinesecs FROM [REGIONAL_OI].[east].MsgDetails msg --join tables full outer join [COI_port].[Mess].agent_data away on msg.Interval=away.int and msg.Person=away.login
WHERE msg.Chat>= getdate()-14

https://stackoverflow.com/questions/65756332/join-2-tables-on-2-different-servers January 17, 2021 at 09:06AM