--怎么个联系法? SELECT * FROM TABLE1 UNION ALL SELECT * FROM TABLE2
笛卡尔乘积联系: SELECT * FROM TABLE1 cross join TABLE2联合联系: SELECT ... FROM TABLE1 union all select ... from TABLE2字段关联 SELECT * FROM TABLE1 join TABLE2 on TABLE2.col = TABLE1.col
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
SELECT * FROM TABLE1 cross join TABLE2联合联系:
SELECT ... FROM TABLE1
union all
select ... from TABLE2字段关联
SELECT * FROM TABLE1 join TABLE2 on TABLE2.col = TABLE1.col
*
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
--两边都就1条的话直接
SELECT * FROM TABLE1,TABLE2