some useful select statement of SQL

1. Temporary Table
    select __
    into Temp_Table
    from __
   where__

2. Recursive Select
   with Sub(f1,f2)
   as
  (select f11,f22
   from table1
  where __
  union all
  select f111,f222
  from table2
  where __
 )

3.Multi_table join
  select __
  from (select __ from table1 as A inner join table2 as B on A.f1=B.f1 where __) as C
            right outer join table3 as D on C.f1=D.f1
  where __
  group by __
  order by__