title: Can you rename a table using the keyword 'AS' and a select statement?
body: <p>This is probably a stupid question to most of you but I was wondering whether you can rename a column using the 'AS' keyword and a select statement?</p>
  
  <p>Here is my SQL:</p>
  
  <pre><code>Select Main.EmpId
          , Associate_List.costCenter, Assignments.Area
          , Main.Assignments_1 AS (
              Select Assignment_Name 
                  from Assignments 
                  where Assignment_Number = 1 
                      and Assignments.Area = '@Someparemeter'
          )
  from associate_list
      , main
      , APU_CC
      , Assignments 
  where Main.Empid = Associate_List.Empid 
      and substring(Associate_List.CostCenter,1,4) = APU_CC.CostCentre
  </code></pre>
  
  <p>The only part of SQL I'm wondering about is:</p>
  
  <pre><code>Main.Assignments_1 AS (
      Select Assignment_Name 
          from Assignments 
          where Assignment_Number = 1 
              and Assignments.Area = '@Someparemeter'
  )
  </code></pre>
  
  <p>Is this possible or am I talking jibberish or is this just a stupid thing to do?</p>
  
  <p>Many Thanks</p>