关于一个sql语句

[loverdotnet]

select pplt,count(*) as ct from resume group by pplt as t1 join
select pplt,count(*) as ct,pht from resume where datediff(dd,Getdate(),pht)>0 and lz='false' group by pplt,pht as t2
on t1.pplt=t2.pplt


提示as附近有错误，知道的帮帮忙吧

[jinjazz]

select * from(
select pplt,count(*) as ct from resume group by pplt) t1 inner join(
select pplt,count(*) as ct,pht from resume where datediff(dd,Getdate(),pht)>0 and lz='false' group by pplt,pht) t2
on t1.pplt=t2.pplt

[loverdotnet]

后面还有两句，麻烦帮一下忙
select pplt,count(*) as ct,pld from resume where datediff(mm,Getdate(),pld)=0 and lz='true' group by pplt,pld
select pplt,count(*) as ct,pld from resume where datediff(mm,Getdate(),ptr)=0 and lz='false' group by pplt,pld

[ws_hgo]

[Quote=引用 2 楼 loverdotnet 的回复:]
后面还有两句，麻烦帮一下忙
select pplt,count(*) as ct,pld from resume where datediff(mm,Getdate(),pld)=0 and lz='true' group by pplt,pld
select pplt,count(*) as ct,pld from resume where datediff(mm,Getdate(),ptr)=0 and lz='false' group by pplt,pld
[/Quote]
这2句话
干什么啊

[Fibona]

select pplt,count(*) as ct,pld from resume where datediff(mm,Getdate(),pld)=0 and lz='true' group by pplt,pld 
union all
select pplt,count(*) as ct,pld from resume where datediff(mm,Getdate(),ptr)=0 and lz='false' group by pplt,pld 

不知道楼主第二个问题要得到什么
是下面的结果还是什么?

select * from( 
select pplt,count(*) as ct from resume group by pplt)  t1 inner join( 
select pplt,count(*) as ct,pld from resume where datediff(mm,Getdate(),pld)=0 and lz='true' group by pplt,pld 
union all
select pplt,count(*) as ct,pld from resume where datediff(mm,Getdate(),ptr)=0 and lz='false' group by pplt,pld 
)t2

on t1.pplt=t2.pplt

[zlb789]

select * from(
select pplt,count(*) as ct from resume group by pplt) t1
inner join
( select pplt,count(*) as ct,pht from resume where datediff(dd,Getdate(),pht)>0 and lz='false' group by pplt,pht) t2
inner join
(select pplt,count(*) as ct,pld from resume where datediff(mm,Getdate(),pld)=0 and lz='true' group by pplt,pld
)as t3
inner join
(select pplt,count(*) as ct,pld from resume where datediff(mm,Getdate(),ptr)=0 and lz='false' group by pplt,pld )as t4
on t1.pplt=t2.pplt and t1.pplt=t3.pplt and t1.pplt=t4.pplt

可以根据不同选择不同的连接方式 left join /right join / inner jion