title: WHERE clause using OPENQUERY with linked server
body: <p>I connect with <em>MS SQL Server Express 2012</em> a Database via ODBC.</p>
  
  <p>My query:</p>
  
  <pre><code>Select * from openquery(test,'SELECT * FROM Versuchsanlage_DB WHERE value =27')
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/fNMhD.png" alt="SQL QUERY"></p>
  
  <p>But this query</p>
  
  <pre><code> Select * from openquery(test,
     'SELECT * FROM Versuchsanlage_DB 
      WHERE identifier = AGENT.OBJECTS.Versuchsanlage.Variable_1_Byte')
  </code></pre>
  
  <p>OR</p>
  
  <pre><code>Select * from openquery(test,
     'SELECT * FROM Versuchsanlage_DB
      WHERE identifier = Variable_1_Byte')
  </code></pre>
  
  <p>doesn't work. Why?</p>