with 
       cte(Num) as 
       ( 
              select 1 as Num 
              union all 
              select 1.2 
       )
       , cte2(Num2) as 
       (
              select 2 as Num2
       )
select * 
from 
       cte cross join cte2
;
No comments:
Post a Comment