title: Select statement without subqueries
body: <p>I have two tables (simplified example)</p>
  
  <p>1 Config:</p>
  
  <pre><code>ConfigId|Settings
  </code></pre>
  
  <p>2 ReplacesConfig:</p>
  
  <pre><code>ConfigId|ReplaceWithConfigId
  </code></pre>
  
  <p>So lets say I got three rows in Config (ConfigId 1,2,3) and two rows in ReplacesConfig like this</p>
  
  <pre><code>1|2
  2|3
  </code></pre>
  
  <p>This means that all config with Id 1 will be replaced with configId 2. But we also have one record that replaces all configId 2 with configId 3. So this means when I want to read the settings from ConfigId 1 I should get the settings from ConfigId 3. It could be more then two leves, so need a way which support this.</p>
  
  <p>The select statement must be supported in a indexed view, so cannot use subqueries. </p>