title: Invalid object name in sql view
body: <p>I cannot use synomyms in my project because of some deployment restrictions so instead, I created this view:</p>
  
  <pre><code>CREATE VIEW [dbo].[User] AS SELECT * FROM [PersonalData].[dbo].[User] 
  GO
  </code></pre>
  
  <p>It worked OK but now I need to modify it as follow:</p>
  
  <pre><code>ALTER VIEW [dbo].[User] AS 
      SELECT [Id],
      t.[Name] AS [Title],
      [FirstName],
      [LastName],
      [JobTitle],
      [Department],
      [EmailAddress],
      [PhoneNumber],
      [PhoneExtension],
      [MobilePhoneNumber],
      [CreatedDate],
      [ModifiedDate],
      [Uid],
      [Active]
      FROM [PersonalData].[dbo].[User] AS u
      LEFT OUTER JOIN [PersonalData].[dbo].[Titles] AS t ON u.TitleId = t.Id 
  GO
  </code></pre>
  
  <p>Currently, it fails with: </p>
  
  <pre><code>Ambiguous column name 'Id'
  </code></pre>
  
  <p>in the <code>LEFT OUTER JOIN</code> line. </p>
  
  <p>However, the Microsoft SQL Management Studio highlights <code>[PersonalData].[dbo].[Titles]</code> with the error: </p>
  
  <pre><code>Invalid object name '[PersonalData].[dbo].[Titles]
  </code></pre>
  
  <p>In fact, it doesn´t provide me IntelliSense for that table's columns.</p>
  
  <p>The table <code>[PersonalData].[dbo].[Titles]</code> is there. In fact, the following query returns results with no errors:</p>
  
  <pre><code>select * from [PersonalData].[dbo].[Titles]
  </code></pre>
  
  <p>My knowledge about SQL is not deep enough but I don´t understand why this is, why it finds <code>Users</code> table but doesn´t find <code>Titles</code>. </p>
  
  <p>A little more context:</p>
  
  <ul>
  <li>The view that I am creating is not in the <code>PersonalData</code> database but in other database called <code>Platform</code>.</li>
  <li>I checked the context and it is OK, I am creating the view in <code>Platform</code> database.</li>
  </ul>
  
  <p>Why does it happen?</p>