title: Using entire query as table name in SQL
body: <p>How to name an entire select statement query as a table--></p>
  
  <p>(select col1, col2, col3</p>
  
  <p>from customers..</p>
  
  <p>where col1....) as Table1;</p>
  
  <p>I want to do this for 3 tables which then i keep on using in the same SQL Syntax. The operations I later perform on these tables (Table1, Table2, Table3) are- combining them (TableX) , counting values from Table1 with some filters and displaying as a column next to TableX. </p>
  
  <p>I am able to do this in Microsoft Access, because I can store all three tables, separately manipulate them with filters, and then write individual queries for combining and counting and displaying results as one final table. I am not able to write a single start to end query in SQL. Please help!</p>