title: Correct syntax for SQL join
body: <p>Please can somebody help me with the correct syntax for this join.</p>
  
  <p>I keep getting the below error:</p>
  
  <p>"The objects "dbo.APRW14_FFA68878_Calls" and "dbo.APRW14_FFA68878_Calls" in the FROM clause have the same exposed names. Use correlation names to distinguish them."</p>
  
  <p>Here is my code:</p>
  
  <pre><code>select [APRW14_FFA68878_Calls].[customer lookup], [dbo].[Customers].[Customer Name]
  from [dbo].[APRW14_FFA68878_Calls]
  join [dbo].[APRW14_FFA68878_Calls] on [dbo].[APRW14_FFA68878_Calls].[customer lookup] = [dbo].[Customers].[Customer Name]
  </code></pre>
  
  <p>Can anyone help with the correct syntax?</p>
  
  <p>Thanks</p>