title: sql linked server join query
body: <p>I am having issues running any query on joining a local DB with a DB from a linked server.</p>
  
  <p>My query:</p>
  
  <pre><code>SELECT 
  
          [LocalDatabase].[dbo].[Record].[Project_ID],
          [LinkedServer].[Reporting].[dbo].[Active].[Name]
  
          FROM [LocalDatabase].[dbo].[Record] inner join 
               [LinkedServer].[Reporting].[dbo].[Active] ON
               [LocalDatabase].[dbo].[Record].[Project_ID] = [LinkedServer].[Reporting].[dbo].[Active].[Delivery_Number]
  </code></pre>
  
  <p>The errors:</p>
  
  <pre><code>Msg 4104, Level 16, State 1, Line 9
  The multi-part identifier "LinkedServer.Reporting.dbo.Active.Delivery_Number" could not be bound.
  Msg 4104, Level 16, State 1, Line 5
  The multi-part identifier "LinkedServer.Reporting.dbo.Active.Name" could not be bound.
  </code></pre>
  
  <p>I am guessing my syntax is incorrect but I am unable to fix it.
  Can someone please suggest a solution?</p>
  
  <p>If there is a better solution for me to run a select query on 2 databases which are on different servers, please mention it.</p>