sql查询

2008-01-15 12:12:04 169 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

我有两个甚至多个sql语句如果查出的结果类似这样，怎么把他们合并到一个里面去，难道一定要先插到临时表？
month age1
------ -----------
03 69
04 50
没有行受影响。
(返回 1 行)
month age2
------ -----------
03 480
04 100
没有行受影响。

希望结果
month age1 age2
-------------------
03 69 480
04 50 100
难道只能用临时表吗？这样一来不是慢死啊，有没有什么好办法？

...全文

wishY

MS-SQL Server 34,876 成员 254,635 内容

+ 关注 + 加入社区

切换为时间正序

威尔亨特 2008-01-16

打赏
举报

left join ..... on ...

JL99000 2008-01-16

打赏
举报

select a.month,a.age1,b.age2 from (这里放你得到第一表的查询语句 ) as a left join (这个放你得到第二表的查询语句) b
on a.month=b.month
正确
接分

wishY 2008-01-15

打赏
举报

那我不是要写死啊，贴个sql语句，用来统计年龄段的。



declare @sql1 nvarchar(1000)

	set @sql1 = 'SELECT [month] ,sum([count]) as age1 FROM (SELECT Convert(nvarchar(2),d.CheckTime,101) as [month] ,COUNT(DATEDIFF(yy, P.Birthday, GETDATE()))as [count]

	FROM Deals as D INNER JOIN Houses as H ON D.HouseID = H.HouseID inner join Peoples P on D.BuyID = P.PeopleID '

	set @sql1 = @sql1 + ' where Convert(nvarchar(4),d.CheckTime,102) = '''+@year+''' '

	if  @cishu = '1'

	begin

		if  @term <> ''

		set @sql1 = @sql1 + ' and h.XiangMu like ''%'+@term+'%'' '

	end

	else

	begin

		if @term <> ''	

		set @sql1 = @sql1 + ' and (h.XiangMu like ''%'+@term+'%'' or replace((h.lu + h.Nong + ''弄''),'' '','''') like ''%'+@term+'%''  )'

	end

	

	set @sql1 = @sql1 + '  group by DATEDIFF(yy, P.Birthday, GETDATE()),Convert(nvarchar(2),d.CheckTime,101) having DATEDIFF(yy, P.Birthday, GETDATE()) < 18) AS 临时表 group by [month]'

	if  @month <> ''

	set @sql1 = @sql1 + ' having [month] = '''+@month+''' '

	if  @season <> ''

	begin

		if @season = '1'

		set @sql1 = @sql1 + ' having [month] between 1 and 3 '

		if @season = '2'

		set @sql1 = @sql1 +  ' having [month] between 4 and 6 '

		if @season = '3'

		set @sql1 = @sql1 +  ' having [month] between 7 and 9 '

		if @season = '4'

		set @sql1 = @sql1 +  ' having [month] between 10 and 12 '

	end

	

	exec sp_executesql @sql1

有没有办法用一个写出来啊，我现在想只能换条件 DATEDIFF(yy, P.Birthday, GETDATE()) < 18 查出不同年龄段的了。

dobear_0922 2008-01-15

打赏
举报

表名都搞得一样，呵呵
来握个手，，，

dobear_0922 2008-01-15

打赏
举报

select a.month,age1,age2 

from (select month,age1 from ...) a

     join (select month,age2 from ...) b on a.month=b.month

-狙击手- 2008-01-15

打赏
举报

select a.month,b.age1,b.age2

from (select month ,......) a

left join (select month ,......) b  on.a.month = b.month

dobear_0922 2008-01-15

打赏
举报

可以试试联合查询

sp4 2008-01-15

打赏
举报

乱