select a.id,a.s,b.r
from
(
select px=row_number()over(order by getdate()),* from tablea
) as a
inner join
(
select px=row_number()over(order by getdate()),* from tableb
)
on
a.px=b.px
from
(
select px=row_number()over(order by getdate()),* from tablea
) as a
inner join
(
select px=row_number()over(order by getdate()),* from tableb
)
on
a.px=b.px
from
(
select px=row_number()over(order by getdate()),* from tablea
) as a
inner join
(
select px=row_number()over(order by getdate()),* from tableb
)
on
a.px=b.px
from
(
select px=row_number()over(order by getdate()),* from tablea
) as a
inner join
(
select px=row_number()over(order by getdate()),* from tableb
)
on
a.px=b.px
from
(
select px=row_number()over(order by getdate()),* from tablea
) as a
FULL join
(
select px=row_number()over(order by getdate()),* from tableb
) as b
on
a.px=b.px
SELECT '1'AS c,'aa'id,'11'number UNION ALL
SELECT '2','bb','22'
), cte2 AS(
SELECT '1'AS e,'FF'AS R UNION ALL
SELECT '2','TT'
)
SELECT * INTO Temp_A from cte CROSS JOIN cte2SELECT * FROM Temp_A WHERE e=1