title: SQL - Select statement in brackets
body: <p>is there a solution for putting the select statement in brackets or something like this?</p>
  
  <p>I need to perform this:</p>
  
  <pre><code>select t1.plz, t1.help, t1.me AS...
  </code></pre>
  
  <p>The Problem is, that my columns getting from a variable and my code perform this</p>
  
  <pre><code>select t1.plz, help, me
  </code></pre>
  
  <p>It works to the point i join it with an other table and the key gets mixed up. This works - <strong>t2.key, car,</strong>...
  but
  <strong>t2.car,key</strong> not, because i need to rename key as key2 and without the t2.key in front it doenst work...long story.
  I need to get that t1./t2. in front of every column.</p>
  
  <p>Is there a solution for this problem?</p>
  
  <p>My Code(SAS)</p>
  
  <pre><code>create table work.test as
  select t1.&amp;string1 t2.&amp;string2
  </code></pre>
  
  <p>I can´t put the t1. in front of every string, because i perform a loop, so this would end in a t1.plz, t1.t1.help, t1.t1.t1,me.</p>