Question

这似乎非常简单,但我只能说出这一点。我只想合并两个表格。我不关心哪些价值观与这些价值观相配。举例说:

declare @tbl1 table(id int)  
declare @tbl2 table(id int)  

insert @tbl1 values(1)  
insert @tbl1 values(2)  
insert @tbl2 values(3)  
insert @tbl2 values(4)  
insert @tbl2 values(5)  

select * from @tbl1, @tbl2

This returns 6 rows, but what kind of query will generate this (just slap the tables side-by-side):
1 3
2 4
null 5

Answer 1

你们可以提供每个桌位数,然后加入:

WITH
Table1WithRowNumber as (
    select row_number() over (order by id) as RowNumber, id from Table1
),

Table2WithRowNumber as (
    select row_number() over (order by id) as RowNumber, id from Table2
)

SELECT Table1WithRowNumber.Id, Table2WithRowNumber.Id as Id2
FROM Table1WithRowNumber 
FULL OUTER JOIN Table2WithRowNumber ON Table1WithRowNumber.RowNumber = Table2WithRowNumber.RowNumber

www.un.org/chinese/ga/president

Answer 2

使用十字架

  Select * From tableA Cross Join TableB

但是,大家理解,在表中所列各行的产出中,你会一行。 A with each Row in TableB...

So if Table A has 8 rows, and TableB has 4 rows, you will get 32 rows of data... If you want any less than that, you have to specify some join criteria, that will filter out the extra rows from the output

Answer 3

这些工作是:

Select A.ID, B.ID From
  (SELECT ROW_NUMBER () OVER (ORDER BY ID) AS RowNumber, ID FROM Tbl2 ) A
full outer join
  (SELECT ROW_NUMBER () OVER (ORDER BY ID) AS RowNumber, ID FROM Tbl1 ) B 
on (A.RowNumber=B.RowNumber)

Answer 4

这里也适用了LQ1交叉条目。

Select * 
From tableA, TableB

友情链接