22,209
社区成员
发帖
与我相关
我的任务
分享
--两边都就1条的话直接
SELECT * FROM TABLE1,TABLE2
[Quote=引用 3 楼 wanglejun 的回复:]select
*
from
(select id=row_number()over(order by getdate()),* from ta)a
join
(select id=row_number()over(order by getdate()),* from tb)b
on
a.id=b.id
--怎么个联系法?
SELECT * FROM TABLE1
UNION ALL
SELECT * FROM TABLE2