title: Unable to understand query
body: <p>I am working on an SSIS job that contains a complex query.</p>
  
  <p>It has some thing like :</p>
  
  <pre><code> some sql statements
  
   left outer join
  
   (
      select query joining two more tables )
  
   table1
  </code></pre>
  
  <p>here, i am unable to understand what that table1 mean ? Is it a kind of temporary view</p>
  
  <p>created . This table1 is used in the other parts of query . But, actually the table1 does </p>
  
  <p>exists in the database. </p>
  
  <p>Is it like , the results of the select query in the parenthesis is created as table1</p>
  
  <p>Please clarify me on this..</p>
  
  <p>I am not able to put down my code because of Security Policies</p>