两个查询结果和到一起怎么写?

[gqs2105]

SELECT xianjin
FROM consume
WHERE (zt <> '3')

SELECT XFJE
FROM Jiaoban
WHERE jbid='2'

如何把这两个结果连起来得到下边的结果
xianjin XFJE
data1 data2
data3 data4
data5 data6

[windsea123]

SELECT xianjin
FROM consume
WHERE (zt <> '3')

UNION

SELECT XFJE
FROM Jiaoban
WHERE jbid='2'

[yangqidong]

两个查询的结果行数一定是一样的吗

[zhu4139365]

[Quote=引用 1 楼 windsea123 的回复:]

SELECT xianjin 
FROM consume 
WHERE (zt <> '3') 

UNION 

SELECT XFJE 
FROM Jiaoban 
WHERE jbid='2' 

[/Quote]

[zhensoft163]

创建零时表，字段为xianjin XFJE

create table #Temp1
 (
    xianjin  VARCHAR(50),
    XFJE VARCHAR(50)
 }

然后把查询的结果保存到这张零时表

INSERT INTO #Temp1(xianjin ,XFJE)
(SELECT xianjin FROM consume WHERE (zt <> '3')) ,
(SELECT XFJE FROM Jiaoban WHERE jbid='2' )

select * from #Temp1

试试看，应该可以的

[双层木屋]

一个简单的思路是利用行号建立对等关系。例如：

SELECT * FROM
(SELECT ROW_NUMBER() AS ROWNUM, xianjin FROM consume WHERE (zt <> '3')) AS T1
LEFT JOIN
(SELECT ROW_NUMBER() AS ROWNUM, XFJE FROM Jiaoban WHERE jbid='2') AS T2 ON T1.ROWNUM = T2.ROWNUM

[xiua411]

稍微改动一下顶楼上的
SELECT * FROM
(SELECT ROW_NUMBER() over(order by xianjin) AS ROWNUM, xianjin FROM consume WHERE zt <> '3' group by xianjin) AS T1
LEFT JOIN
(SELECT ROW_NUMBER() over(order by XFJE) AS ROWNUM, XFJE FROM Jiaoban WHERE jbid='2' group by XFJE) AS T2 ON T1.ROWNUM = T2.ROWNUM

[z050301402]

最简单的方法是申明一个表变量来存放就好了

[mabailin]

顶

[z050301402]

4楼的方法可以用 顶

[rainsome]

用 FULL OUTER JOIN或许为佳.

[Quote=引用 5 楼 LouGnib 的回复:]
一个简单的思路是利用行号建立对等关系。例如：

SELECT * FROM
(SELECTROW_NUMBER() AS ROWNUM, xianjin FROM consume WHERE (zt <> '3')) AS T1
LEFT JOIN
(SELECTROW_NUMBER() AS ROWNUM, XFJE FROM Jiaoban WHERE jbid='2') AS T2ON T1.ROWNUM = T2.ROWNUM


[/Quote]