title: SQL Server why Incorrect syntax near the keyword 'select'
body: <pre><code>select *
  from 
      (select * 
       from 
           (select t1.stdid
           from t1) as table1
       cross join 
           select * 
           from 
               (select t2.Subid
                from t2) as table2
      ) as table3
  </code></pre>